Can you list all companies based in Austin and their revenues?
select name,revenue from manufacturers where headquarter = 'Austin'
Can you list all companies whose revenue is less than 100?
select name from manufacturers where revenue<100
Thanks! What is the respective revenues of Hewlett-Packard and Winchester?
select name,revenue from manufacturers where revenue<100