LU04.A02 - SQL : DQL - Select from several tables

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

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

• a) Create a adress-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