Dies ist eine alte Version des Dokuments!


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

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

ERD eines Shops

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

Supplier and PrWe need a list with product details as following:

  • Supplier name
  • Supplier phone
  • ProductID
  • ProductName
  • Units
  • Price

The list must be be sorted by 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

arningunits:lu04:aufgaben:screenshot_2024-09-03_143510.png?600|}}

English German

Volkan Demir

  • modul/m290/learningunits/lu04/aufgaben/a02.1725367422.txt.gz
  • Zuletzt geändert: 2024/09/03 14:43
  • von vdemir