human
Schema:
buildings (id, name, City, Height, Stories, Status)
Companies (id, name, Headquarters, Industry, Sales_billion, Profits_billion, Assets_billion, Market_Value_billion)
Office_locations (building_id, company_id, move_in_year)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the sales for each company!
assistant
SELECT id , sales_billion FROM Companies;
human
Also, include the industry they are in!
assistant
SELECT id , sales_billion , industry FROM Companies;
human
Which ones are not in the Banking industry?
assistant
SELECT id , sales_billion , industry FROM Companies WHERE Industry != 'Banking';
human
What are the minimum and maximum sales?
assistant
SELECT MAX( Sales_billion ) , MIN( Sales_billion ) FROM Companies WHERE Industry != "Banking" ;