Exercise 1
Practice crafting a SQL query to count the number of employees working on project P1 using given EMPLOYEE and SALARY tables. This exercise helps learners apply SQL querying skills focused on data retrieval and joining tables effectively.
We'll cover the following...
We'll cover the following...
Problem statement
Write a SQL query to fetch the count of employees working on project ‘P1’.
Input
The following tables are available to you as inputs:
EMPLOYEE Table
| Emp_Id | Full_ |
|---|
SALARY Table
| Emp_Id | Project |
|---|