solulubeta
Sign in
SQL / Window functions & CTEs
06.08 · SQL

Quarter at a glance

Turn monthly revenue into columns. For each category with sales in January–March 2024, return category, jan, feb, mar: that category's revenue in each month (0 when it sold nothing that month).

Hard 3 min Pro

This lesson is part of solulu Pro

Turn monthly revenue into columns. For each category with sales in January–March 2024, return category, jan, feb, mar: that category's revenue in each month (0 when it sold nothing that month).

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 63 of 77 · updated 2026-10-12