Company: Phonepe ML engineer_19april
Difficulty: medium
You are given a table bank that holds customer transaction data, containing detailed transactional information about customers from a financial institution. Task Write the SQL query to retrieve customer IDs for transactions that occurred in the month of December, irrespective of the year. The results should be arranged in ascending order of Customer_ID . Table description Input format Table: bank Name Type Description Info_Date Date Represents the date the bank got the customer information. Customer_ID Int Represents the customer ID. Transactions Int Represents the number of bank transactions made by the customer. Amount Int Represents the total amount in the customer's bank account. Output format Name Type Description Customer_ID Int Represents the ID of the customer with transactions in December . Example Input table Table: bank Info_Date Customer_ID Transactions Amount 2022-12-28 1 30 100000 2022-10-31 2 12 2000 2021-12-23 3 30 [unclear] 2013-07-02 4 50 [unclear] [unclear] 5 18 1030