Identify instances where the exchange rate for a specific currency fluctuated by more than 5% within a week.
SELECT * FROM currencies WHERE currency_code = ‘AUD’ AND ABS((MAX(exchange_rate) – MIN(exchange_rate)) / MIN(exchange_rate) * 100) > 5 AND date BETWEEN ‘2021-01-01’ AND ‘2021-01-07’