SQL: Age and Salary Filtering | Dataford Interview Questions

Given a scenario, write an SQL query to retrieve customers with age between 20 and 30 and salary greater than a specific amount, so that an insurance campaign can be sent to them.

Asked in the 1st Round Technical Interview stage.

Use the customers and customer_financial_profiles tables. Apply a salary threshold of 75000.

Output

Return one row per qualifying customer with customer_id, customer_name, age, and salary.
Include ages from 20 through 30 and salaries strictly greater than 75000.
Order by age ascending, salary descending, then customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name
age	INT	Customer age in years
email	VARCHAR(150)	Customer email address

customer_financial_profiles

Column	Type	Description
profile_idPK	INT	Unique financial profile identifier
customer_id	INT	Referenced customer identifier
salary	NUMERIC(12,2)	Annual customer salary
employment_status	VARCHAR(30)	Current employment status

Your question is SQL: Age and Salary Filtering. Start with the requirements and the two tables 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