SQL · Databricks · Medium
Given a SQL table named sales, write a query that adds together all sales made in each calendar month and presents the monthly totals in chronological month order. Assume the table includes these fields: Constraints Each row represents one sale. Multiple rows may belong to the same month and must be combined. Months are identified in YYYY-MM format. Months with no sales do not need to appear in the result. Sort the returned months from earliest to latest. Examples Example 1…
Checking your access…