What are some companies with more than 200 sales?
select name from company where sales_in_billion > 200
Can you sort the list in descending order of sales and profits
select name from company where sales_in_billion > 200 order by sales_in_billion, profits_in_billion desc
How many companies are in the list?
select count ( * ) from company where sales_in_billion > 200 order by sales_in_billion, profits_in_billion desc
Can you show me the list in descending order of sales and profits again?
select name from company where sales_in_billion > 200 order by sales_in_billion, profits_in_billion desc