Can you tell me the names of all compatible browsers and accelerators?
select t2.name, t3.name from accelerator_compatible_browser as t1 join browser as t2 on t1.browser_id = t2.id join web_client_accelerator as t3 on t1.accelerator_id = t3.id
Can you also show their compatible years?
select t2.name, t3.name, t1.compatible_since_year from accelerator_compatible_browser as t1 join browser as t2 on t1.browser_id = t2.id join web_client_accelerator as t3 on t1.accelerator_id = t3.id
Hmm, can you list the names of all compatible browsers and accelerators in the descending order of compatible year?
select t2.name, t3.name from accelerator_compatible_browser as t1 join browser as t2 on t1.browser_id = t2.id join web_client_accelerator as t3 on t1.accelerator_id = t3.id order by t1.compatible_since_year desc