What are the names of all companies whose revenue is smaller than the revenue of all companies based in Austin?
select name from manufacturers where revenue < ( select min ( revenue ) from manufacturers where headquarter = 'Austin' )
What are the companies' revenues whose revenue is smaller than the revenue of all companies based in Austin?
select revenue from manufacturers where revenue < ( select min ( revenue ) from manufacturers where headquarter = 'Austin' )
What is the numerical value of those two companies' revenues?
select name,revenue from manufacturers where revenue < ( select min ( revenue ) from manufacturers where headquarter = 'Austin' )
What are the names of all companies whose revenue is larger than the revenue of all companies based in Austin?
select name from manufacturers where revenue > ( select min ( revenue ) from manufacturers where headquarter = 'Austin' )
What are the numerical values of their revenues, please?
select name,revenue from manufacturers where revenue > ( select min ( revenue ) from manufacturers where headquarter = 'Austin' )