Consider the following tables and assume they have been crea

Consider the following tables and assume they have been created:

Use SQL to manipulate the data and extract the following information (provide SQL query):

How many salespersons have sold Product Number 21765?

Solution

SELECT COUNT(*) FROM SALES
WHERE ProdNum = 21765
//This will filter rows having prodNum 21765
//No of rows after filter, will be the number of sales person
//because (SPNum,ProdNum) is the PK of Sales table