financial Database Schema

Database Description

Banking database with accounts, clients, loans, and transactions.

Schema Structure
Schema information not available for this database.
Example Queries

SQL Query:
SELECT T1.account_id FROM trans AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE STRFTIME('%Y', T1.date) = '1998' AND T1.operation = 'VYBER KARTOU' AND T1.amount < (SELECT AVG(amount) FROM trans WHERE STRFTIME('%Y', date) = '1998')
Evidence:

Operation = 'VYBER KARTOU' refers to credit card withdrawal

Difficulty: moderate

SQL Query:
SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN disp AS T2 ON T1.account_id = T2.account_id WHERE T2.type = 'OWNER' AND T1.frequency = 'POPLATEK TYDNE'
Evidence:

'POPLATEK TYDNE' stands for weekly issuance

Difficulty: simple

SQL Query:
SELECT T1.account_id FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE STRFTIME('%Y', T2.date) = '1993' AND T1.duration > 12 ORDER BY T1.amount DESC LIMIT 1
Evidence:

Loan validity more than 12 months refers to duration > 12

Difficulty: moderate

SQL Query:
SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN loan AS T3 ON T1.account_id = T3.account_id WHERE T1.district_id = 1 AND (T3.status = 'C' OR T3.status = 'D')
Evidence:

Status = 'C' stands for running contract, OK so far; Status = 'D' stands for running contract, client in debt

Difficulty: moderate

SQL Query:
SELECT CAST((SUM(IIF(T3.date = '1998-12-27', T3.balance, 0)) - SUM(IIF(T3.date = '1993-03-22', T3.balance, 0))) AS REAL) * 100 / SUM(IIF(T3.date = '1993-03-22', T3.balance, 0)) FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id INNER JOIN trans AS T3 ON T3.account_id = T2.account_id WHERE T1.date = '1993-07-05'
Evidence:

Increase rate of his/her account balance = [(balance of date A - balance of date B) / balance of Date B] * 100%

Difficulty: challenging
Back to Database Explorer