Time & dates
Exercise · SQL & Querying

Predict, then run it

Predict the output

gigs(paid_on, fee) spans two years: Jan-2024 100, Jan-2025 150, Feb-2025 60. Monthly revenue as a trend (each real month separate):

SELECT strftime(date_trunc('month', paid_on), '%Y-%m') AS m, SUM(fee) AS fees FROM gigs GROUP BY date_trunc('month', paid_on) ORDER BY 1;

Predict the exact output.