Question

query should return the names of the people who are reported to(excluding null values), the number of members that report to them, and the average age of those members as an integer. The row should be ordered by the names in alphabetical order

Answer 1

Answer:

You can use the select statement to retrieve the information. Avg functions can be used to return average age. Order by clause can be used to sort the result in ascending order.