Write a query to return the total movie rental revenue for each month. For Postgres: you can use EXTRACT(MONTH FROM colname) and EXTRACT(YEAR FROM colname) to extract month and year from a timestamp c

SELECT
 EXTRACT(YEAR FROM payment_ts) AS year,
 EXTRACT(MONTH FROM payment_ts) AS mon,
 SUM(amount) as rev
FROM payment
GROUP BY year, mon
ORDER BY year, mon;

select     
    EXTRACT(YEAR FROM CAST(payment_ts as DATE) ) as yea,
    EXTRACT(MONTH FROM CAST(payment_ts as DATE) ) as mon,
    sum(amount)
from payment
    group by EXTRACT(MONTH FROM CAST(payment_ts as DATE) ),
     EXTRACT(YEAR FROM CAST(payment_ts as DATE) ) 
    order by 
     EXTRACT(MONTH FROM CAST(payment_ts as DATE) ),
      EXTRACT(YEAR FROM CAST(payment_ts as DATE) )