GV4_biological_with

SELECT GV4_15 as "TA", GV4_18 as "DT", GV4_19 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
UNION
SELECT GV4_9 as "TA", GV4_12 as "DT", GV4_20 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
UNION
SELECT GV4_3 as "TA", GV4_6 as "DT", GV4_21 as "Year", countryCode as "country_code"
FROM [WISE_UWWTD].[latest].[CP_source]
order by country_code, Year