Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:aufgaben:a04 [2024/09/04 14:32] – vdemir
+++ modul:m290:learningunits:lu04:aufgaben:a04 [2024/10/17 12:35] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU04.A04 - SQL-DQL: Selects with Aggregate Functions ======
+====== LU06.A03 - SQL-DQL: Selects with Aggregate Functions ======
 ===== Requirements  =====
   * Work type: individual
-  * Timeframe: 20 Minutes
+  * Timeframe: 30 Minutes
   * Means of aid:
       * only teaching materials, no websearch, no use of ai.
@@ Zeile 11: / Zeile 11: @@
 ===== Case studies / Assignments =====
 The following ERD describes a order database for a a shop.
 ===== Assignments =====
 The general assignment is to develop DQL commands that matches the requirements below:
-==== Assignment a: MIN ====
+==== A: MIN ====
-We want to know which of our products is actually the most expensive.
+We want to know which of our products actually the cheapest is.
-  SELECT max(price)
-  FROM Products;
-==== Assignment b: MAX ====
-What is the lowest price among the products of the supplier with the id = 12.
-  SELECT max(price)
-  FROM Products
-  WHERE SupplierID = 12;
- ====
+==== B: MAX ====
+What is the highest price for the products of the supplier with id = 12?
+==== C: AVG ====
+What is the average price for products of supplier 3?
+==== D: COUNT ====
+How many orders do we currently have in our data-base system from the customer with id = 5?
+==== E: SUM ====
+What is the worth of the order 10255? Please note, that there are two tables involved in this select statement.
-==== Assignment c) ====
+==== F: GROUP BY ====
-...
+For our anual report we need list of the orders, and the value of each, grouped by the OrderID.
 ===== Solution =====
-[[modul:m290:learningunits:lu04:loesungen:l02|Lösung]]
+[[modul:m290:learningunits:lu04:loesungen:l03|Lösung]]
 ===== Vocabulary =====