Retrieve KARL STORZ Customer Records | Dataford Interview Questions

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.

Schema

customers

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

Your question is Retrieve KARL STORZ Customer Records. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

This is a single-table query, so focus on selecting the right columns, filtering correctly, and applying the required sort order.

Schema

customers

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

Your question is Retrieve KARL STORZ Customer Records. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.