Banking Database SQL Practice Exercises
Bank system with branches, customers, accounts, transactions, and loans
3 ExercisesBeginner to Advanced Level
Customer and Branch Queries
Beginner01
SELECT from customers and branches with filtering
Topics Covered:
SELECTWHEREORDER BY
Sample Query:
SELECT first_name, last_name, branch_id FROM customers ORDER BY last_name;Account Balances by Type
Intermediate02
GROUP BY account_type and sum balances
Topics Covered:
GROUP BYSUMORDER BY
Sample Query:
SELECT account_type, SUM(balance) as total_balance FROM accounts GROUP BY accoun...Transactions with Customer Names
Intermediate03
JOIN transactions, accounts, and customers
Topics Covered:
JOINMultiple tables
Sample Query:
SELECT t.transaction_date, t.amount, c.last_name FROM transactions t JOIN accoun...Ready for Free Practice?
Explore the banking database database on your own. Write any SQL query and see results instantly.
Open SQL Practice Environment