Java, Spring Boot, MySQL Basics | Dataford Interview Questions

Questions on Java, MySQL, and Spring Boot

For the SQL portion, write a PostgreSQL query using the provided users and orders tables. Return customers whose completed-order total is greater than the average completed-order total among customers with completed orders.

Output

One row per qualifying customer.
Columns: user_id, user_name, completed_order_count, and total_completed_amount.
Include only completed orders in the count and total.
Sort by total_completed_amount descending, then user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User's display name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
user_id	INT	User associated with the order
status	VARCHAR(20)	Order state
amount	NUMERIC(10,2)	Order amount

Your question is Java, Spring Boot, MySQL Basics. 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