Retrieve KARL STORZ Customer Records | Dataford Interview Questions

Task

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.

Problem

Task

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

Problem

Task

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

Problem

Task

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