What distinct accelerator names are compatible with Firefox.
select distinct t1.name from web_client_accelerator as t1 join accelerator_compatible_browser as t2 on t2.accelerator_id = t1.id join browser as t3 on t2.browser_id = t3.id where t3.name = "Firefox"
What distinct accelerator names are compatible with the browsers that have a market share higher than 15.
select distinct t1.name from web_client_accelerator as t1 join accelerator_compatible_browser as t2 on t2.accelerator_id = t1.id join browser as t3 on t2.browser_id = t3.id where t3.market_share > 15
What distinct accelerator names have been compatible since at least 1996.
select distinct t2.name from accelerator_compatible_browser as t1 join web_client_accelerator as t2 on t1.accelerator_id = t2.id where compatible_since_year > = 1996
Out of these accelerators which are compatible with browsers that have a market share higher than 25.
select distinct t2.name from accelerator_compatible_browser as t1 join web_client_accelerator as t2 on t1.accelerator_id = t2.id join browser as t3 on t3.id = t1.browser_id where t1.compatible_since_year > = 1996 and t3.market_share > 25