Your question is Retrieve KARL STORZ Customer Records. Start with the requirements and the one table 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.
You are given a customers table from a KARL STORZ reporting dataset. Write a SQL query to retrieve the customer_id, customer_name, country, and created_at for customers whose status is 'Active'. Return the results ordered by created_at from newest to oldest.
This is a single-table query, so focus on selecting the right columns, filtering correctly, and applying the required sort order.
| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer name |
| country | VARCHAR(50) | Country where the customer is based |
| status | VARCHAR(20) | Customer lifecycle status such as Active, Inactive, or Prospect |
| created_at | DATE | Date the customer record was created |