Cold Case~65min
The Sleeper Account
An account dormant for 3 years suddenly received ₹47 lakh and transferred it out within 48 hours. KYC was updated 2 days before. New beneficiary added the morning of the transfer.
Tables you'll query
accountstransactionskyc_recordsbeneficiaries
What you'll learn
Window FunctionsCTEs (WITH clause)JOINsDate & Time FunctionsSubqueries