Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!