Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:loesungen:l03 [2024/09/27 12:54] – [F: GROUP BY] vdemir
+++ modul:m290:learningunits:lu04:loesungen:l03 [2024/10/17 12:35] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU05.S03 - SQL-DQL: Selects with Aggregate Functions ======
+====== LU06.S03 - SQL-DQL: Selects with Aggregate Functions ======
 ==== A: MIN ====
-We want to know which of our products actually the most expensive is.
+We want to know which of our products actually the cheapest is.
   SELECT min(price)
@@ Zeile 13: / Zeile 13: @@
 ==== B: MAX ====
-What is the lowest price for the products of the supplier with id = 12?
+What is the highest price for the products of the supplier with id = 12?
   SELECT max(price)
@@ Zeile 55: / Zeile 55: @@
   WHERE OrderDetails.ProductID = Products.ProductID
   GROUP BY OrderDetails.orderid;
+*** Result from the db:**
+{{:modul:m290:learningunits:lu04:loesungen:lusdfas..png?600|}}