modul:m290:learningunits:lu04:aufgaben:a02

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu04:aufgaben:a02 [2024/09/03 14:54] – vdemirmodul: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  ===== ===== Requirements  =====
Zeile 17: Zeile 17:
 The 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 ====
 We need a list with product details as following: We need a list with product details as following:
   * Name of the supplier   * Name of the supplier
Zeile 28: Zeile 28:
  
  
-==== 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".  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:  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   * CustomerID
  • modul/m290/learningunits/lu04/aufgaben/a02.1725368060.txt.gz
  • Zuletzt geändert: 2024/09/03 14:54
  • von vdemir