what is the Id of the browser that is compatible with most web accelerators?
select t1.id from browser as t1 join accelerator_compatible_browser as t2 on t1.id = t2.browser_id group by t1.id order by count ( * ) desc limit 1
What is the name of browser with id 1?
select name from browser where id = 1
What is the name of the browser with the second largest market share?
select name from browser order by market_share limit 2
* I have left the chat *
select t1.name from browser as t1 join accelerator_compatible_browser as t2 on t1.id = t2.browser_id order by compatible_since_year asc limit 1