Median Transaction Amount per Day

Google/Amazon level task. **Condition:** For each day, calculate the median amount of bank transactions. **Table:** bank_transactions (transaction_id, amount, transaction_date, ...) **Requirements:** 1. For each date, find the median of transaction amounts 2. If even number, average of the two central values 3. Round to 2 decimal places **Hint:** Use PERCENTILE_CONT(0.5) or the ROW_NUMBER and COUNT trick.