SELECT 'GLE' AS "Indicator",
       (SELECT lifeexpectancy FROM country WHERE governmentform = 'Federal Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Federal republic",
       (SELECT lifeexpectancy FROM country WHERE governmentform = 'Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Republic",
       (SELECT lifeexpectancy FROM country WHERE lifeexpectancy IS NOT NULL AND governmentform != 'Republic' AND governmentform != 'Federal Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Other"
UNION SELECT 'LLE' AS "Indicator",
       (SELECT lifeexpectancy FROM country WHERE governmentform = 'Federal Republic' ORDER BY lifeexpectancy LIMIT 1),
       (SELECT lifeexpectancy FROM country WHERE governmentform = 'Republic' ORDER BY lifeexpectancy LIMIT 1),
       (SELECT lifeexpectancy FROM country WHERE lifeexpectancy IS NOT NULL AND governmentform != 'Republic' AND governmentform != 'Federal Republic' ORDER BY lifeexpectancy LIMIT 1)
ORDER BY "Indicator"
LIMIT 2;