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/08/30 13:58] – vdemirmodul:m290:learningunits:lu04:aufgaben:a01 [2024/10/17 12:35] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU04.A01 - SQL : DQL commands======+====== LU06.A01 - SQL-DQL: Select from one table ======
  
 ===== Requirements  ===== ===== Requirements  =====
   * Work type: individual   * Work type: individual
 +  * Timeframe: 15 Minutes
   * Means of aid:    * Means of aid: 
       * only teaching materials, no websearch, no use of ai.       * only teaching materials, no websearch, no use of ai.
       * [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_columns | W3Schools | SQL Editor]]       * [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_columns | W3Schools | SQL Editor]]
-  * Timeframe: 1 Minutes +  * Expected result: Semsntically and syntactically correct SQL statements according to the requirements of the case studies. 
-  * Expected result: Sementically and syntactically SQL statements according to the requirements of the case studies. The resultset match the specified template.+
  
-===== Case studies / Asignments =====+===== Case studies / Assignments =====
 Go to the W3-Schools SQL Editore and develop DQL commands to the following requirements Go to the W3-Schools SQL Editore and develop DQL commands to the following requirements
  
-a) A adress-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending. +===== Assignments =====
- +
-  Select CustomerName, Address, PostalCode, Country +
-  from customers +
-  order by country; +
- +
-{{:modul:m290:learningunits:lu04:aufgaben:screenshot_2024-08-30_135600.png?600|}} +
- +
-b)+
  
 +  * 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.
 +  * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.
  
 ===== Solution ===== ===== Solution =====
-[[modul:m290:learningunits:lu02:loesungen:l01|Lösung]]+[[modul:m290:learningunits:lu04:loesungen:l01|Lösung]]
  
  
Zeile 30: Zeile 25:
 ^ English ^ German ^  ^ English ^ German ^ 
 | respectively | beziehungsweise| | 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 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir
  • modul/m290/learningunits/lu04/aufgaben/a01.1725019105.txt.gz
  • Zuletzt geändert: 2024/08/30 13:58
  • von vdemir