SQL Practice+Prompt Engineering

Build Data & AI Skills with Real Business Scenarios

Practice SQL with live query execution and Prompt Engineering with an AI sandbox — both graded against real business scenarios across Banking, CRM, Customer Service, HR, and more.

Start Practising →Browse Questions

SQL Topics

SQL JOINsWindow FunctionsGROUP BY & AggregatesSubqueriesCTEsCASE WHENDate FunctionsSelf Joins

Prompt Engineering Topics

Zero-shot PromptingFew-shot PromptingRole PromptingChain-of-thoughtSystem PromptsOutput FormattingConstraints & Guardrails

Sample SQL Questions

1IntermediateBankingSELECT and WHERE ClausesAggregate Functions (COUNT, SUM, AVG, MAX, MIN)

How many customers have opened an account in the last month?

From: PracticeSet01

2IntermediateBankingSELECT and WHERE ClausesAggregate Functions (COUNT, SUM, AVG, MAX, MIN)

What is the total balance of all accounts in the bank?

From: PracticeSet01

3IntermediateBankingGROUP BY and HAVINGSelf-Joins

What is the total balance for each customer in the bank?

From: PtacticeSet02

4IntermediateBankingGROUP BY and HAVINGSelf-Joins

How many accounts does each customer have, but only include customers with more than 2 accounts?

From: PtacticeSet02

5IntermediateBankingSELECT and WHERE ClausesGROUP BY and HAVING

How many customers have a balance greater than $10,000?

From: PracticeSet03

6IntermediateBankingSELECT and WHERE ClausesGROUP BY and HAVING

List the total number of accounts for each customer with a balance over $5,000.

From: PracticeSet03

7IntermediateBankingSELECT and WHERE ClausesAggregate Functions (COUNT, SUM, AVG, MAX, MIN)

How many customers have a balance greater than $10,000?

From: PracticeSet04

8IntermediateBankingSELECT and WHERE ClausesAggregate Functions (COUNT, SUM, AVG, MAX, MIN)

What is the average account balance of all customers?

From: PracticeSet04

9IntermediateBankingAggregate Functions (COUNT, SUM, AVG, MAX, MIN)GROUP BY and HAVING

How many customers have accounts in the bank?

From: PracticeSet05

10IntermediateBankingAggregate Functions (COUNT, SUM, AVG, MAX, MIN)GROUP BY and HAVING

What is the average account balance for all accounts?

From: PracticeSet05

Ready to sharpen your SQL skills?

Get assigned practice sets, run queries live, receive AI-powered hints, and track your scores.