SELECT image_humans.image_id,
    image_humans.rect,
    image_humans.age_val,
    image_humans.age_score,
    image_humans.gender,
    image_humans.gender_score,
    image_humans.race,
    image_humans.expression_score,
    image_humans.smile,
    image_humans.updated_on,
    image_humans.human_score,
    image_humans.is_archived,
    image_humans.face_type,
    image_humans.status_age,
    image_humans.status_gender,
    image_humans.status_expression,
    image_humans.id,
        CASE
            WHEN lower(image_humans.age) = 'infant'::text THEN  'Child'::text
            WHEN lower(image_humans.age) = 'child'::text THEN  'Child'::text
            WHEN lower(image_humans.age) = 'teen'::text THEN  'Child'::text
            WHEN lower(image_humans.age) = 'adult'::text THEN  'Adult'::text
            WHEN lower(image_humans.age) = 'toddler'::text THEN  'Child'::text
            WHEN lower(image_humans.age) = 'youth'::text THEN  'Child'::text
            WHEN lower(image_humans.age) = 'senior'::text THEN  'Adult'::text
            WHEN lower(image_humans.age) = 'young adult'::text THEN  'Adult'::text
            ELSE image_humans.age
        END AS age,
        CASE
            WHEN lower(image_humans.expression) = 'surprise'::text THEN 'Happy'::text
            WHEN lower(image_humans.expression) = 'serious'::text THEN 'Neutral'::text
            WHEN lower(image_humans.expression) = 'neutral'::text THEN 'Neutral'::text
            WHEN lower(image_humans.expression) = 'love'::text THEN 'Happy'::text
            WHEN lower(image_humans.expression) = 'angry'::text THEN 'Sadness'::text
            WHEN lower(image_humans.expression) = 'fear'::text THEN 'Sadness'::text
            WHEN lower(image_humans.expression) = 'disgusted'::text THEN 'Sadness'::text
            WHEN lower(image_humans.expression) = 'sadness'::text THEN 'Sadness'::text
            WHEN lower(image_humans.expression) = 'joy'::text THEN 'Happy'::text
            WHEN lower(image_humans.expression) = 'happy'::text THEN 'Happy'::text
            ELSE image_humans.expression
        END AS expression
   FROM image_humans;