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
How many companies have an industry of banking?
assistant
SELECT COUNT( * ) FROM Companies WHERE Industry = 'Banking';
human
How many don't have a banking industry?
assistant
SELECT COUNT( * ) FROM Companies WHERE Industry ! = 'Banking';
human
What are the total sales of those companies?
assistant
SELECT SUM( sales_billion ) FROM Companies WHERE Industry ! = "Banking" ;