Sql |
-- Note: Unless you save your query, these tabs will NOT persist if you clear your cookies or change browsers.
SELECT indicator as full_indicator,
CASE WHEN indicator = 'Children 0-4 years' THEN 'a.0-4 Years'
WHEN indicator = 'Children 5-9 years' THEN 'b.5-9 Years'
WHEN indicator = 'Children 10-17 years' THEN 'c.10-17 Years'
WHEN indicator = 'Percentage of children under 18 living with at least one biological parent' THEN 'Leaving with at least one biological parent'
WHEN indicator = 'Percentage of children under 18 who have lost both parents' THEN 'Lost both parents'
WHEN indicator = 'Percentage of children under 18 who have lost one parent' THEN 'Lost one parent'
ELSE indicator END AS indicator,
CASE WHEN indicator = 'Children 0-4 years' THEN 'a.0-4 Years'
WHEN indicator = 'Children 5-9 years' THEN 'b.5-9 Years'
WHEN indicator = 'Children 10-17 years' THEN 'c.10-17 Years'
WHEN indicator = 'Percentage of children under 18 living with at least one biological parent' THEN 'កំពុងរស់នៅយ៉ាងហោចណាស់ជាមួយឪពុក ឬម្ដាយបង្កើត'
WHEN indicator = 'Percentage of children under 18 who have lost both parents' THEN 'បានបាត់បង់ឪពុក ឬម្ដាយ'
WHEN indicator = 'Percentage of children under 18 who have lost one parent' THEN 'បានបាត់បង់ទាំងឪពុក និងម្ដាយ'
ELSE indicator END AS indicator_khmer,
value,source
FROM summary.demographics_data_table
|