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:

Create a free account to view this lesson.

Continue your learning journey with a 14-day free trial.

By signing up, you agree to Educative's Terms of Service and Privacy Policy