Question

consider the above database and execute the following queries

1. display the count of employees department wise.
2. display the name of the employee of who is 'manager' of "Account department".
3. display the name of department whose location is "pune" and "Mr. Advait" is working on it.
4. display the names of employees whose salary is greater than 50000 and department is "Quality".
5. Update date of joining of employee to '15/06/2019' whose department is 'computer science' and name is "Mr.roy' .​​

Answer 1

Answer:

You can use the COUNT function in the SELECT statement to get the number of employees, the number of employees in each department, the number of employees who hold a specific job, etc. The following illustrates the syntax of the SQL COUNT function: COUNT([ALL | DISTINCT] expression);