Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:loesungen:l03 [2024/09/27 12:48] – [D: COUNT] 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 45: / Zeile 45: @@
   WHERE orderDetails.OrderID = 10255
   AND OrderDetails.ProductID = Products.ProductID;
+**Result from the db:** 3115.75
 ==== F: GROUP BY ====
 For our anual report we need list of the orders, and the value of each, grouped by the OrderID.
-  SELECT sum(price*quantity)
+  SELECT OrderDetails.orderID, sum(price*quantity)
   FROM OrderDetails, Products
-  WHERE orderDetails.OrderID = 10255
+  WHERE OrderDetails.ProductID = Products.ProductID
-  AND OrderDetails.ProductID = Products.ProductID;
+  GROUP BY OrderDetails.orderid;
+*** Result from the db:**
+{{:modul:m290:learningunits:lu04:loesungen:lusdfas..png?600|}}
 ===== Vocabulary =====