LU05.A03 - SQL-DQL: Selects with Aggregate Functions

• Work type: individual
• Timeframe: 30 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 actually the cheapest is.

What is the highest price for the products of the supplier with id = 12?

What is the average price for products of supplier 3?

How many orders do we currently have in our data-base system from the customer with id = 5?

What is the worth of the order 10255? Please note, that there are two tables involved in this select statement.

For our anual report we need list of the orders, and the value of each, grouped by the OrderID.

Lösung

Volkan Demir