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, 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
Who is the founder of Sony?
assistant
SELECT founder FROM manufacturers WHERE name = 'Sony'
human
How many companies were created by Andy?
assistant
SELECT count(*) FROM manufacturers WHERE founder = 'Andy'
human
Where is the headquarter of the company founded by James?
assistant
SELECT headquarter FROM manufacturers WHERE founder = 'James'
human
Who is the founders of companies whose first letter is S?
assistant
SELECT founder FROM manufacturers WHERE name LIKE "S%" ;