human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
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
What are the average, maximum and total revenues of all companies?
assistant
SELECT avg(revenue) , max(revenue) , sum(revenue) FROM manufacturers
human
Find the total revenue for each manufacturer.
assistant
SELECT sum(revenue) , name FROM manufacturers GROUP BY name
human
Find the name, headquarter and founder of the manufacturer that has the highest revenue.
assistant
SELECT name , headquarter , founder FROM manufacturers ORDER BY revenue DESC LIMIT 1
human
Find all manufacturers' names and their headquarters, sorted by the ones with highest revenue first.
assistant
SELECT name , headquarter FROM manufacturers ORDER BY revenue DESC
human
What are the names, headquarters and revenues for manufacturers, sorted by revenue descending?
assistant
SELECT name , headquarter , revenue FROM manufacturers ORDER BY revenue DESC ;