Show TV3_2 MetArt

select country_code, ShowTV3_2HasMet, ShowTV3_2NotMet, ShowTV3_2HasMet + ShowTV3_2NotMet as "ShowTV3_2"
from (
SELECT countryCode as "country_code", 
IIF(TV3_2_METART3 = '', 0, 1) + IIF(TV3_2_METART4 = '', 0, 1) + IIF(TV3_2_METART5 = '', 0, 1) as "ShowTV3_2HasMet",
IIF(TV3_4 is null, 0, CEILING(TV3_4)) + IIF(TV3_5 is null, 0, CEILING(TV3_5)) + IIF(TV3_6 is null, 0, CEILING(TV3_6)) as "ShowTV3_2NotMet"
FROM [UWWTD].[v1r2].[CP_source]) as A