American Express Data Analyst interview questions

SQL Question 1: Identify the VIP Customers for American Express For American Express, a key activity may be the use of an American Express Card for transactions. 'Whale' users or VIP users could be defined as those customers who have a high frequency of transactions above a certain threshold (e.g. $5000). Given a transaction table, write a SQL query to identify these 'Whale' users. transactions Example Input: transaction_id customer_id transaction_date transaction_amount 001 C001 08/01/2022 00:00:00 4800 002 C002 08/02/2022 00:00:00 6800 003 C003 08/03/2022 00:00:00 5000 004 C001 08/10/2022 00:00:00 5200 005 C002 08/22/2022 00:00:00 7000 Example Output: customer_id transaction_count C001 2 C002 2

Analyzing the problem and the question