LU05.A02 - SQL-DQL: Select from multiple tables

• Work type: individual
• Timeframe: 30 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.

The following ERD describes a order database for a a shop.

The general assignment is to develop DQL commands that matches the requirements below:

We need a list with product details as following:

• Name of the supplier
• Supplier phone
• Product ID
• Name of the product
• Units
• Price

The list must be be sorted by the suppliername in descending order.

Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier „Leka Trading“.

We would like to know what products the customer „Hanari Carnes“ has ordered in the past. Sort the list by the quantity. detail we require the following data:

• CustomerID
• CustomerName
• OrderID
• OrderDate
• Quantity
• ProductName
• CategoryName

Lösung

Volkan Demir