Using a CTE named delivered that holds only delivered orders, count them as delivered_orders.
delivered
delivered_orders
1 row with column delivered_orders
Run your code to see the output here.