#NoPayJan Offer - Access all CloudxLab Courses for free between 1st to 31st Jan

  Enroll Now >>

Write and execute a query to list out managers names and count of employees reporting to them.

How many managers have more than 2 reportees?

Note: the data is stored in emp table and deptt table in retail_db in MySQL as described earlier.

INSTRUCTIONS

Do self join on emp to get employee and their manager names, then use 'group by' on manager and 'having count'.


Note - Having trouble with the assessment engine? Follow the steps listed here


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...