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.