Exercise 3
Practice crafting SQL queries to retrieve project-wise employee counts and sort them by size. Understand how to manipulate data using joins and aggregations to enhance your SQL proficiency.
We'll cover the following...
We'll cover the following...
Problem statement
Write a SQL query to fetch a project-wise count of employees sorted by the project’s count in descending order.
Input
The following tables are available to you as inputs:
EMPLOYEE Table
| Emp_Id |
|---|
SALARY Table
| Emp_Id |
|---|