Practice Interview Questions
| Question | Status |
|---|---|
Bank of Ireland has instructed to identify unauthorized transactions during December 2022.
A transaction is considered invalid if it falls outside the bank's regular hours: Monday to Friday 09:00 - 16:00, closed on Saturdays, Sundays, and Irish Public Holidays (25th and 26th December).
Your task is to find the transaction IDs of such invalid transactions.
transactions table:
| Column Name | Description |
|---|---|
| transaction_id | Unique identifier for each transaction |
| time_stamp | Timestamp of the transaction |
| transaction_id |
|---|
| 1001 |
| 1341 |
| 1413 |
Bank of Ireland has instructed to identify unauthorized transactions during December 2022.
A transaction is considered invalid if it falls outside the bank's regular hours: Monday to Friday 09:00 - 16:00, closed on Saturdays, Sundays, and Irish Public Holidays (25th and 26th December).
Your task is to find the transaction IDs of such invalid transactions.
transactions table:
| Column Name | Description |
|---|---|
| transaction_id | Unique identifier for each transaction |
| time_stamp | Timestamp of the transaction |
| transaction_id |
|---|
| 1001 |
| 1341 |
| 1413 |