Show me all the company names.
select name from operate_company
What are the types of these companies?
select name, type from operate_company
How many companies have type 'Joint Venture'?
select count(*) from operate_company group by type having type = 'Joint Venture'
Tell me the most common company type.
select type, count(*) from operate_company group by type order by count(*) desc limit 1