Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:aufgaben:a01 [2024/09/03 10:26] – vdemir
+++ modul: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  =====
@@ Zeile 7: / Zeile 7: @@
       * only teaching materials, no websearch, no use of ai.
       * [[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 / Assignments =====
@@ Zeile 14: / Zeile 14: @@
 ===== 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.
   * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.