Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CompanyName,
- CASE WHEN Country IN ('USA', 'Canada') THEN 'North America'
- WHEN Country = 'Brazil' THEN 'South America'
- ELSE 'Europe' END AS Continent
- FROM Suppliers
- ORDER BY CompanyName;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement