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 15:21] – vdemirmodul:m290:learningunits:lu04:aufgaben:a01 [2024/10/17 12:35] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU04.L01 - SQL : DQL commands======+====== LU06.A01 - SQL-DQL: Select from one table ======
  
 ===== Requirements  ===== ===== Requirements  =====
Zeile 7: Zeile 7:
       * 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]]
-  * Expected result: Sementically and syntactically SQL statements according to the requirements of the case studies. The resultset match the specified template.+  * Expected result: Semsntically and syntactically correct SQL statements according to the requirements of the case studies. 
  
-===== 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
  
-==== Assignment a) ==== +===== Assignments =====
-Create a adress-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending.+
  
-  Select CustomerName, Address, PostalCode, Country +  * a) Create a address-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending. 
-  from customers +  * b) Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending. 
-  order by country; +  * 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:screenshot_2024-08-30_135600.png?600|}} +
- +
-==== Assignment b) ==== +
-Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending. +
- +
-  SELECT Price, Productname,  Supplierid FROM Products  +
-  WHERE Price BETWEEN 20 AND 45 +
-  ORDER BY Price ASC, SupplierID ASC; +
-   +
-{{:modul:m290:learningunits:lu04:aufgaben:screenshot_2024-08-30_145939.png?600|}} +
- +
-==== Assignment c) ==== +
-Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes. +
- +
-  SELECT * FROM Employees  +
-  WHERE Notes LIKE "%grad%";  +
- +
-{{:modul:m290:learningunits:lu04:aufgaben:screenshot_2024-08-30_151200.png?600|}}+
  
 ===== Solution ===== ===== Solution =====
Zeile 45: 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.1725024083.txt.gz
  • Zuletzt geändert: 2024/08/30 15:21
  • von vdemir