Skip to main content

15. Count the no. of salesmen currently having orders.

SELECT
    COUNT(snum),
    snum
FROM
    orders
GROUP by
    snum;

Output:

d