6. EXTRACT Used to extract parts of timestamp/date Syntax EXTRACT (field from date/time/interval) SELECT EXTRACT(day from rental_date), COUNT(*) FROM rental GROUP BY EXTRACT(day from rental_date) ORDER BY COUNT(*) DESC * Challenge Write a query to find out the following: 1) What's the month with the highest total payment amount? 2) What's the day of week with the highest total payment amount?(0 ..
