branch { branch_id, branch_name, no_of_employee, city, address } here branch_id is primary key......
SELECT SUM(no_of_employee) AS [Total Employees], city FROM branch GROUP BY city
SELECT SUM(no_of_employee) FROM branch WHERE city = 'SURAT'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)