Practice the essentials
In this exercise you are preparing list of your top paying active customers. The data you will need are the names of the customer sorted by the amount they paid.
Deze oefening maakt deel uit van de cursus
Applying SQL to Real-World Problems
Oefeninstructies
- Return the
first_name,last_nameandamount. INNER JOINthe tables you need for this query:paymentandcustomerusing thecustomer_idfor the join.- Ensure only
activecustomers are returned. - Sort the results in
DESCending order by the amount paid.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT ___,
___,
___
FROM ___ AS p
INNER JOIN ___ AS c
ON p.___ = c.___
WHERE ___
ORDER BY ___ ___;