- Transactions that exceed the customer's average check by 5 times. (Used aggregation to find average amount, tried RIGHT JOIN and SUBQUERY)
- Customers with quick recurring transactions (less than a 5-minute difference). (Used LAG, DATEDIFF, and CTE)
- Transactions with unusual devices. (MISSING VALUES)
Code link(https://drive.google.com/file/d/15aigsyZcGGaoUBpqVl7JAdJA4IBqjnDS/view?usp=drive_link)