Company: Phonepe ML engineer_19april

Difficulty: medium

Problem Statement

Problem Description You're working with a dataset from a financial institution. The bank table logs customer activity, including the date each record was captured, how many transactions occurred, and the account balance at that time. Write a SQL query that returns the distinct Customer_ID s of every customer who has an activity record dated in December , no matter which year. Sort the final result 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 filtering condition looks only at the month portion of

More Phonepe ML engineer_19april OA questionsInterview experiences