human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the total revenue of companies of each founder.
assistant
SELECT sum(revenue) , founder FROM manufacturers GROUP BY founder
human
Find the name of companies whose revenue is between 100 and 150.
assistant
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150
human
Find the number of manufactures that are based in Tokyo or Beijing.
assistant
SELECT count(*) FROM manufacturers WHERE headquarter = 'Tokyo' OR headquarter = 'Beijing'
human
Find the total revenue for each manufacturer.
assistant
SELECT sum(revenue) , name FROM manufacturers GROUP BY name
human
What are the average, maximum and total revenues of all companies?
assistant
SELECT avg(revenue) , max(revenue) , sum(revenue) FROM manufacturers
human
What is the total revenue of all companies whose main office is at Tokyo or Taiwan?
assistant
SELECT SUM( revenue ) FROM manufacturers WHERE Headquarter = "Tokyo" OR Headquarter = "Taiwan" ;