LU05.A01 - SQL-DQL: Select from one table

• Work type: individual
• Timeframe: 15 Minutes
• Means of aid:
  • only teaching materials, no websearch, no use of ai.
  • W3Schools | SQL Editor
• Expected result: Semsntically and syntactically correct SQL statements according to the requirements of the case studies.

Go to the W3-Schools SQL Editore and develop DQL commands to the following requirements

• 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.

Lösung

Volkan Demir