LU04.A01 - SQL : DQL commands

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

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

Create a adress-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending.

Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending.

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