Antwoorden

Opdracht 6.1

Wat is de naam van de track die het langste duurt?

select name 
from Track 
where Milliseconds = (
    select max(Milliseconds) 
    from Track);

Opdracht 6.2

Wat is de naam van de track die het kortste duurt?

select name 
from Track 
where Milliseconds = (
    select min(Milliseconds) 
    from Track);

Opdracht 6.3

Welke albums zijn nog nooit verkocht?

select name 
from track
where trackid not in (
    select t.trackid
    from Track as T, InvoiceLine as I
    where t.trackid = I.trackid);

Opdracht 6.4

Wat is de duurste bestelling ooit geweest?

select invoiceID, sum(UnitPrice * Quantity) 
from InvoiceLine 
group by InvoiceID 
order by sum(UnitPrice  * Quantity) 
desc Limit 1;

Opdracht 6.5

Welke klant heeft dat besteld?

select DISTINCT Customer.firstname, customer.lastname
from customer, Invoice, Invoiceline
where Customer.CustomerID = Invoice.CustomerID AND
    Invoice.InvoiceID = (
        select invoiceID
        from InvoiceLine 
        group by InvoiceID 
        order by sum(UnitPrice  * Quantity) 
        desc Limit 1);