Exercise 1

This first exercise will test your knowledge of aggregate functions.

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
...