SQL Group-By Operator

Sales(model, date, color, units)

SELECT model, color, SUM(units)

FROM Sales

WHERE date >= “1/1/90”

GROUP BY model, color

Previous slide

Next slide

Back to first slide

View graphic version