Table: root_ns
Columns: letter
ipv6_address
as_number
operator
location_sites_global_local
software

Question: What is the location for the software of BIND and an IPv6 address of 2001:503:c27::2:30?
SQL: SELECT "location_sites_global_local" FROM root_ns WHERE "software" = 'bind' AND "ipv6_address" = '2001:503:c27::2:30'

Question: Which IPv6 address had a location of distributed using anycast 8/0 and a letter of A?
SQL: SELECT "ipv6_address" FROM root_ns WHERE "location_sites_global_local" = 'distributed using anycast 8/0' AND "letter" = 'a'

Question: Which IPv6 address has an operator of Wide project?
SQL: SELECT "ipv6_address" FROM root_ns WHERE "operator" = 'wide project'

Question: Which letter has an operator of VeriSign and an AS-number of AS26415?
SQL: SELECT "letter" FROM root_ns WHERE "operator" = 'verisign' AND "as_number" = 'as26415'

Question: Which location has an AS-number of N/A?
SQL: SELECT "location_sites_global_local" FROM root_ns WHERE "as_number" = 'n/a'

Question: Which letter has an operator of the Defense Information Systems Agency?
SQL: SELECT "letter" FROM root_ns WHERE "operator" = 'defense information systems agency'