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
Find the name of companies whose revenue is greater than the average revenue of all companies.
assistant
SELECT name FROM manufacturers WHERE revenue > (SELECT avg(revenue) FROM manufacturers)
human
Find the name, headquarter and revenue of all manufacturers sorted by their revenue in the descending order.
assistant
SELECT name , headquarter , revenue FROM manufacturers ORDER BY revenue DESC
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 the total revenue for each manufacturer.
assistant
SELECT sum(revenue) , name FROM manufacturers GROUP BY name
human
Find the total revenue of companies of each founder.
assistant
SELECT SUM( revenue ) , founder FROM manufacturers GROUP BY founder ;