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):

List the names of the products of which salesperson Adams has sold more than 2000 units.

Solution

Answer:

Below is the query which will fullfill the requirement

select p.prodname from product p, sales s, salesperson sp where sp.spname=\'Adams\' and sp.spnum = s.spnum and s.prodnum = p.prodnum and s.quantity>2000;