LU04.A01 - SQL : DQL commands

• Work type: individual
• Means of aid:
  • only teaching materials, no websearch, no use of ai.
  • W3Schools | SQL Editor
• Timeframe: 1 Minutes
• 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

a) 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
from customers
order by country;

b)

Lösung

Volkan Demir