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 cheapest one.

SELECT max(price{{:modul:m290:learningunits:lu04:aufgaben:screenshot_2024-09-03_143510.png?600|}})
FROM Products;

What is the lowest price of the prod …

…

Lösung

Volkan Demir