select * from vg order by global_sales desc limit 10; select platform, sum(global_sales) as total_sales from vg group by platform order by total_sales desc; select ...