Company: Phonepe ML engineer_19april
Difficulty: medium
Problem Description You are working with a financial institution's dataset. The bank table contains records of customer activity, including the date information was recorded, transaction counts, and account balances. Write a SQL query to retrieve a list of unique Customer_ID s for all customers who had activity recorded in the month of December , regardless of the year. The final result should be sorted by Customer_ID in ascending order. Schema Table: bank Column Name Type Description Info_Date Date The date the bank recorded the customer's information. Customer_ID Int The unique identifier for the customer. Transactions Int The number of transactions made by the customer as of that date. Amount Int The total balance in the customer's account. Required Output Column Name Type Description Customer_ID Int The ID of the customer with activity in December. The results must be sorted by Customer_ID in ascending order. Constraints or Notes The filter must apply to the month of the Info_Date