what is the average of market value?
select avg ( market_value ) from company
what is the average of assets billion?
select avg ( assets_billion ) from company
what is companies headquarters?
select headquarters from company
show all headquarters without a company in banking industry.
select headquarters from company except select headquarters from company where main_industry = 'Banking'