TV9_X year 2016 DISCODATA

select countryCode as "country_code", ISNULL(TV9_1, 0) as TV9_1, ISNULL(TV9_2, 0) as TV9_2, ISNULL(TV9_3, 0) as TV9_3, ISNULL(TV9_4, 0) as TV9_4, ISNULL(TV9_5, 0) as TV9_5, ISNULL(TV9_6, 0) as TV9_6, ISNULL(TV9_7, 0) as TV9_7, ISNULL(TV9_8, 0) as TV9_8, ISNULL(TV9_9, 0) as TV9_9, ISNULL(TV9_10, 0) as TV9_10, ISNULL(TV9_11, 0) as TV9_11, ISNULL(TV9_12, 0) as TV9_12, ISNULL(TV9_13, 0) as TV9_13, ISNULL(TV9_14, 0) as TV9_14, ISNULL(TV9_15, 0) as TV9_15
FROM [UWWTD].[v1r2].[CP_source_WFD2016]