Amazon's customer data team wants to email people whose profile is incomplete, asking them to add the missing details.
List customers whose city or address is missing. Show the city as 'unknown' when it's missing.
Expected output
Return: customer id, email and city (name the columns however you like)
Example of the shape (made-up values):
| customer_id | city | |
|---|---|---|
| 7 | lee.ali7@gmail.com | unknown |
Write your query here. Ctrl + Enter submits.