Using a CTE named delivered that holds only delivered orders, count them as delivered_orders.
delivered
delivered_orders
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.