The customer success team wants a quick contact list of customers from North America, showing each as a single readable row with sensible defaults for missing company info.
| Column | Type |
|---|---|
| CustomerId | INTEGER (Primary Key) |
| FirstName | TEXT NOT NULL |
| LastName | TEXT NOT NULL |
| Company | TEXT |
| Country | TEXT |
| TEXT NOT NULL |
Country is one of: USA, CanadaCustomerName (FirstName + space + LastName), Region (Country in UPPERCASE), Org (Company; if NULL, use the string 'Individual')Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.