BZZ - Modulwiki - en:modul:m290:learningunits:lu04:loesungen https://wiki.bzz.ch/ 2026-04-07T22:10:17+00:00 BZZ - Modulwiki https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-17T10:35:34+00:00 Anonymous (anonymous@undisclosed.example.com) LU06.S01 - SQL-DQL: Select from one table https://wiki.bzz.ch/en/modul/m290/learningunits/lu04/loesungen/l01?rev=1729161334&do=diff LU06.S01 - SQL-DQL: Select from one table Assignment a) Create a address-list of the customers with the columns in this order: CustomerName, Address, PostalCode, Country, ordered by the the Country ascending. Select CustomerName, Address, PostalCode, Country from customers order by country; text/html 2024-10-17T10:35:44+00:00 Anonymous (anonymous@undisclosed.example.com) LU06.S02 - SQL-DQL: Select from multiple tables https://wiki.bzz.ch/en/modul/m290/learningunits/lu04/loesungen/l02?rev=1729161344&do=diff LU06.S02 - SQL-DQL: Select from multiple tables Case studies / Assignments The following ERD describes a order database for a a shop. [ERD eines Shops] Assignments The general assignment is to develop DQL commands that matches the requirements below: Assignment A text/html 2024-10-17T10:35:52+00:00 Anonymous (anonymous@undisclosed.example.com) LU06.S03 - SQL-DQL: Selects with Aggregate Functions https://wiki.bzz.ch/en/modul/m290/learningunits/lu04/loesungen/l03?rev=1729161352&do=diff LU06.S03 - SQL-DQL: Selects with Aggregate Functions A: MIN We want to know which of our products actually the cheapest is. SELECT min(price) FROM Products; Result from DB: 2.5 B: MAX What is the highest price for the products of the supplier with id = 12?