This cheat sheet shows common database queries in core banking systems.
Table: Customers
| CustomerID | Name | Phone | Address | |
|---|---|---|---|---|
| 101 | Alice | [email protected] | 1234567890 | New York |
| 102 | Bob | [email protected] | 0987654321 | Los Angeles |
Query Examples:
SELECT CustomerID, Name, Email, Phone
FROM Customers
WHERE Name = 'Alice';
SELECT * FROM Customers;
Table: Accounts
| AccountID | CustomerID | AccountType | Balance |
|---|---|---|---|
| 201 | 101 | Savings | 15000.00 |
| 202 | 102 | Checking | 8000.00 |
Query Examples:
SELECT AccountID, CustomerID, AccountType, Balance
FROM Accounts
WHERE Balance > 10000;
SELECT *
FROM Accounts
WHERE CustomerID = 101;