Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:aufgaben:a02 [2024/09/03 14:45] – vdemir
+++ modul:m290:learningunits:lu04:aufgaben:a02 [2024/10/17 12:35] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU04.A02 - SQL-DQL: Select from multiple tables======
+====== LU06.A02 - SQL-DQL: Select from multiple tables======
 ===== Requirements  =====
@@ Zeile 8: / Zeile 8: @@
       * [[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) ====
+==== Assignment A ====
-Supplier and PrWe need a list with product details as following:
+We need a list with product details as following:
-  * Supplier name
+  * Name of the supplier
   * Supplier phone
-  * ProductID
+  * Product ID
-  * ProductName
+  * Name of the product
   * Units
   * Price
-The list must be be sorted by SupplierName in descending order.
+The list must be be sorted by the suppliername in descending order.
-==== Assignment b) ====
+==== Assignment B ====
 Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier "Leka Trading".
-==== Assignment c) ====
+==== Assignment C ====
 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:
   * CustomerID