sqlh10.1

-- Oefening 1

SELECT cust_id, COUNT(*) AS orders
FROM Orders;

-- Oefening 2

SELECT cust_id, COUNT(*) AS orders
FROM Orders
GROUP BY cust_id;

-- Oefening 3

SELECT cust_id, COUNT(*) AS orders
FROM Orders
GROUP BY cust_id
HAVING COUNT(*) >= 2;