show the employeeid, employeename (concatenate firstname, a space, and lastname), and a column called dependentcount showing how many dependents each employee has. sort the results descending by how many dependents each employee has. if an employee has no dependents, the dependentcount column should show.
Hints : a. First, write a simple query that SELECTs EmployeeID and the concatenated EmployeeName column from the Employees table
b. Next, add join into the dependents table matching on employeeID
c. Add the COUNT () aggregation andalias it as DependentCount
d. Addthe necessary GROUP BY clause
e. Finally, add the ORDER BY clause to sort the results descending by COUNT() expression