Sql Exercises The Computer Store

Compute the average price of all the products.

Compute the average price of all products with manufacturer code equal to 2.

Compute the number of products with a price larger than or equal to $180.

Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name (in ascending order).

Select the product name, price, and manufacturer name of all the products.

Select the average price of each manufacturer's products, showing only the manufacturer's code.

Select the average price of each manufacturer's products, showing the manufacturer's name.

Select the names of manufacturer whose products have an average price larger than or equal to $150.

Select the name and price of the cheapest product.

Select the name of each manufacturer along with the name and price of its most expensive product.

Select the name of each manufacturer along with the name and price of its most expensive product.

Bibliography
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.