Question

7.11E Write an SQL query that retrieves the total available quantity of sparkling wines. Make sure to display this quantity as “TOTAL_QUANTITY”

7.12E Write a query to select all supplier numbers, together with their supplier name and total number of outstanding orders for each supplier. Include all suppliers in the result, even if there are no outstanding orders for that supplier at the moment.

7.17E Write an SQL query with ALL or ANY to retrieve the name of the product with the highest available quantity.

Answer 1

Below is the query to retrieve the total available quantity of sparkling wines.

->SELECT quantity FROM product WHERE product_name = 'sparkling wines';

query to select all supplier numbers, together with their supplier name and total number of outstanding orders.

-> SELECT supplier number, supplier name, outstanding orders FROM supplier;

query with ALL to retrieve name of the product with highest available quantity.

-> SELECT product_name FROM product WHERE quantity= ALL(SELECT MAX(quantity) FROM product);

Thank You.