modul:m290:learningunits:lu04:aufgaben:a01

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:a01 [2024/09/03 13:19] – vdemirmodul:m290:learningunits:lu04:aufgaben:a01 [2024/10/17 12:35] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU04.A01 - SQL : DQL - Select from one table ======+====== LU06.A01 - SQL-DQL: Select from one table ======
  
 ===== Requirements  ===== ===== Requirements  =====
Zeile 14: Zeile 14:
 ===== Assignments ===== ===== Assignments =====
  
-  * a) Create a adress-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending.+  * a) Create a address-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending.
   * b) Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending.   * b) Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending.
   * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.   * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.
  • modul/m290/learningunits/lu04/aufgaben/a01.1725362379.txt.gz
  • Zuletzt geändert: 2024/09/03 13:19
  • von vdemir