Skip to main content

17. Find out each customer's smallest orders.

SELECT
    cnum,
    MIN(ammount)
FROM
    orders
GROUP BY
    cnum;

Output:

d