SQL for Risk Data Work | Dataford Interview Questions

How much experience do you have with SQL for data extraction and manipulation?

Write a PostgreSQL query using the loan_applications table. Return approved applications with a requested amount of at least 10,000, sorted from the largest requested amount to the smallest.

Output

One row per qualifying application.
Columns: application_id, applicant_id, requested_amount, and status.
Order by requested_amount descending, then application_id ascending for ties.

Schema

loan_applications

Column	Type	Description
application_idPK	INT	Unique identifier for the loan application
applicant_id	VARCHAR(20)	Identifier for the applicant
requested_amount	DECIMAL(12,2)	Amount requested in the application
status	VARCHAR(20)	Current application status

Your question is SQL for Risk Data Work. 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