Your question is Find Customers Missing in Another Table. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Gartner wants to identify active customer accounts in its CRM that have no recorded login to Gartner Digital Markets. Write a PostgreSQL query that returns customers present in the customers table but absent from gartner_logins.
account_status is Active.customer_id, customer_name, and account_status, ordered by customer_id ascending.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer account name |
| account_status | VARCHAR(20) | Current CRM account status |
| Column | Type | Description |
|---|---|---|
| login_idPK | INT | Unique login event identifier |
| customer_id | INT | Customer associated with the login, if known |
| product_name | VARCHAR(100) | Gartner product accessed |