LU04.A04 - SQL-DQL: Selects with Aggregate Functions

• Work type: individual
• Timeframe: 20 Minutes
• Means of aid:
  • only teaching materials, no websearch, no use of ai.
  • W3Schools | SQL Editor
• Expected result: Semantically and syntactically correct SQL statements according to the requirements of the case studies.

The following ERD describes a order database for a a shop.

The general assignment is to develop DQL commands that matches the requirements below:

We want to know which of our products is actually the most expensive.

SELECT max(price)
FROM Products;

What is the lowest price among the products of the supplier with the id = 12.

SELECT max(price) 
FROM Products
WHERE SupplierID = 12;

====

…

Lösung

Volkan Demir