Solution to Exercise 1

Explore how to apply the COUNT() function in SQL to count employees working on a specific project. This lesson explains the use of WHERE clauses for filtering results, helping you understand basic query techniques in relational databases.

We'll cover the following...

Solution
Explanation

Solution

MySQL

SELECT COUNT(EMP_ID)
FROM SALARY 
WHERE PROJECT = 'P1';

Explanation

...