Table: adsl_specs
Columns: version
standard_name
common_name
downstream_rate
upstream_rate

Question: What's the standard name with an ADSL2 version and a 01.5 1.5 mbit/s downstream rate?
SQL: SELECT "standard_name" FROM adsl_specs WHERE "version" = 'adsl2' AND "downstream_rate" = '01.5 1.5 mbit/s'

Question: What's the downstream rate for the Itu g.992.2 having a version of ADSL?
SQL: SELECT "downstream_rate" FROM adsl_specs WHERE "version" = 'adsl' AND "standard_name" = 'itu g.992.2'

Question: What's the version of Itu g.992.3 Annex J?
SQL: SELECT "version" FROM adsl_specs WHERE "standard_name" = 'itu g.992.3 annex j'

Question: What's the version that has a 20.0 mbit/s downstream rate?
SQL: SELECT "version" FROM adsl_specs WHERE "downstream_rate" = '20.0 mbit/s'

Question: What's the standard name that has a common name of ADSL Over Pots and ADSL version?
SQL: SELECT "standard_name" FROM adsl_specs WHERE "version" = 'adsl' AND "common_name" = 'adsl over pots'

Question: What's the upstream rate for Itu g.992.2 with a version of ADSL?
SQL: SELECT "upstream_rate" FROM adsl_specs WHERE "version" = 'adsl' AND "standard_name" = 'itu g.992.2'