Table: dvd_seasons_2
Columns: dvd_name
ep
region_1_us
region_1_can
region_2_uk
region_2_germany
region_4_australia

Question: How many region 4 dates are associated with a region 2 date of July 9, 2007?
SQL: SELECT COUNT("region_4_australia") FROM dvd_seasons_2 WHERE "region_2_uk" = 'July 9, 2007'

Question: What is the region 1 (Canada) date associated with a region 1 (US) date of January 16, 2007?
SQL: SELECT "region_1_can" FROM dvd_seasons_2 WHERE "region_1_us" = 'January 16, 2007'

Question: What is the region 4 (Aus) date associated with a region 1 (US) date of January 16, 2007?
SQL: SELECT "region_4_australia" FROM dvd_seasons_2 WHERE "region_1_us" = 'January 16, 2007'

Question: What is the region 2 (UK) date associated with a region 4 (Aus) date of July 31, 2008?
SQL: SELECT "region_2_uk" FROM dvd_seasons_2 WHERE "region_4_australia" = 'July 31, 2008'

Question: What is the region 1 (Canada) date associated with a region 2 (UK) date of May 18, 2009?
SQL: SELECT "region_1_can" FROM dvd_seasons_2 WHERE "region_2_uk" = 'May 18, 2009'