What manufacturer has the highest revenue?
select name from manufacturers order by revenue desc limit 1
Where is Iomega located?
select headquarter from manufacturers where name = 'Iomega'
What manufacturers on the list are located in Austin?
select name from manufacturers where headquarter = 'Austin'
What is Creative labs revenue?
select revenue from manufacturers where name = 'Creative Labs'
How many companies have a revenue greater than 100.0?
select count ( * ) from manufacturers where revenue>100.0
What is the total revue of those 3 companies?
select sum ( revenue ) from manufacturers where revenue>100.0