On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Custom classifications of business objects
4. Non-matching objects
Custom grouping of business objects
Custom counting of business objects


Perfect! Our store is now introducing a new shipping cost policy: Any package shipped to the US or Canada is free! Now we want to create a report that shows the updated shipping cost for selected orders. Here's a query that will do the job:

    WHEN ship_country = 'USA' OR ship_country = 'Canada' THEN 0.0
  END AS shipping_cost
FROM orders
WHERE order_id BETWEEN 10720 AND 10730;

You may have noticed that we only defined a column value for the US and Canada. What will happen if there's another ship_country value? Let's find out.


Run the template query, and compare the values in the ship_country and shipping_cost columns.

For countries other than the US and Canada, the shipping_cost value is NULL.

Stuck? Here's a hint!