Alacriti, Recently Asked Online Assessments in 14 Mar, 2026 | Customer Activity SQL | Group Anagram Frequency | Aggregation & Hashmaps

Question 1: Customer Activity (SQL) Problem Statement: You are provided with three tables, customers, accounts, and transactions, containing information about bank customers, their accounts, and transaction activity. Your task is to identify the customers who were active. A customer is considered active if: They own at least one account. They made at least 3 transactions in 2024. Their total deposits in 2024 must exceed 50,000. Return: customer_id, full_name, city, total_accounts, total_transactions_2024, total_deposits_2024 in descending order of total_deposits_2024. Table Description: Table: ...