select c.customerid, count(orderid) as "ANZ_ORDERS"
from customers c
join orders o on c.customerid = o.customerid
group by c.customerid
order by 2 desc;