We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
name equipment_type qty price Baseball Baseball 20 5.99 Baseball Bat Baseball 20 22.99 Baseball Glove Baseball 20 11.99 Basketball Basketball 10 11.99 Volleyball Volleyball 4 8.99 Soccer Ball Soccer 15 10.99 Soccer Net Soccer 6 89.50
SELECT equipment_type , SUM(qty) as 'qty' , AVG(price) as 'avg_price' FROM my_table GROUP BY equipment_type ORDER BY equipment_type
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.