Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:aufgaben:a04 [2024/09/04 14:28] – 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) ====
+==== A: MIN ====
-We want to know which of our products is actually the cheapest one.
+We want to know which of our products actually the cheapest is.
-  SELECT max(price)
+==== B: MAX ====
-  FROM Products;
+What is the highest price for the products of the supplier with id = 12?
-{{:modul:m290:learningunits:lu04:aufgaben:screenshot_2024-09-03_143510.png?600|}}
+==== C: AVG ====
+What is the average price for products of supplier 3?
-==== Assignment b) ====
+==== D: COUNT ====
-What is the lowest price of the prod
+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 =====