3 solved exercises

Having

Solutions and examples for MySQL.

Showing 1–3 of 3 problems

  1. 01Show only those manager_id s who handle more than 5 employees
  2. 02Count the total no of employees for each department. Don’t consider employees of job_id AS_PRESS and also consider only those departments where total no of employees is greater than 5
  3. 03Group employees based on the first 3 digit of their phone number. Avoid employees from department no 10 or 20 or 60 and also avoid those groups where total salaries of employees is less than 50000.