Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:aufgaben:a02 [2024/09/03 13:05] – vdemir
+++ modul:m290:learningunits:lu04:aufgaben:a02 [2024/10/17 12:35] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU04.A02 - SQL : DQL - Select from several tables======
+====== LU06.A02 - SQL-DQL: Select from multiple tables======
 ===== Requirements  =====
   * Work type: individual
-  * Timeframe: 20 Minutes
+  * Timeframe: 30 Minutes
   * Means of aid:
       * only teaching materials, no websearch, no use of ai.
       * [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_columns | W3Schools | SQL Editor]]
   * Expected result: Semantically and syntactically correct SQL statements according to the requirements of the case studies.
-  *
 ===== Case studies / Assignments =====
@@ Zeile 16: / Zeile 15: @@
 ===== Assignments =====
-You general assignment is to develop DQL commands that matches the requirements below:
+The general assignment is to develop DQL commands that matches the requirements below:
+==== Assignment A ====
+We need a list with product details as following:
+  * Name of the supplier
+  * Supplier phone
+  * Product ID
+  * Name of the product
+  * Units
+  * Price
+The list must be be sorted by the suppliername in descending order.
-  * a) We need a list with product details as following:
+==== Assignment B ====
-    * Supplier name
+Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier "Leka Trading".
-    * Supplier phone
-    * ProductID
-    * ProductName
-    * Units
-    * Price
-    * Ordered by SupplierName descending
-  SELECT s.SupplierName, s.Phone, p.ProductID, p.ProductName, p.Units, p.Price,
+==== Assignment C ====
-  FROM Suppliers s, Product p
+We would like to know what products the customer "Hanari Carnes" has ordered in the past. Sort the list by the quantity. detail we require the following data:
-  WHERE s.SupplierID = p.SupplierID;
+  * CustomerID
+  * CustomerName
-  * b) Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending.
+  * OrderID
-  * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.
+  * OrderDate
+  * Quantity
+  * ProductName
+  * CategoryName
 ===== Solution =====
 [[modul:m290:learningunits:lu04:loesungen:l02|Lösung]]
 ===== Vocabulary =====
 ^ English ^ German ^
-| respectively | beziehungsweise|
+| ... | ...|
-| assignment | Auftrag |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir