Help with SQL$,$ please!

We have the following database: world

CREATE TABLE public.city $($

id int$4$ NOT NULL,

"name" text NOT NULL,

countrycode bpchar$(3)$ NOT NULL,

district text NOT NULL,

population int$4$ NOT NULL,

CONSTRAINT city$\_$pkey PRIMARY KEY $($id$)$

$)$;

$--$ public.city foreign keys

ALTER TABLE public.city ADD CONSTRAINT city$\_$fk FOREIGN KEY $($countrycode$)$ REFERENCES public.country$($code$)$;

CREATE TABLE public.country $($

code bpchar$(3)$ NOT NULL,

"name" text NOT NULL,

continent text NOT NULL,

region text NOT NULL,

surfacearea float$4$ NOT NULL,

indepyear int$2$ NULL,

population int$4$ NOT NULL,

lifeexpectancy float$4$ NULL,

gnp numeric$(10,2)$ NULL,

gnpold numeric$(10,2)$ NULL,

localname text NOT NULL,

governmentform text NOT NULL,

headofstate text NULL,

capital int$4$ NULL,

code$2$ bpchar$(2)$ NOT NULL,

CONSTRAINT country$\_$continent$\_$check CHECK $((($continent $=$ 'Asia'::text$)$ OR $($continent $=$ 'Europe'::text$)$ OR $($continent $=$ 'North America'::text$)$ OR $($continent $=$ 'Africa'::text$)$ OR $($continent $=$ 'Oceania'::text$)$ OR $($continent $=$ 'Antarctica'::text$)$ OR $($continent $=$ 'South America'::text$))),$

CONSTRAINT country$\_$pkey PRIMARY KEY $($code$)$

$)$;

$--$ public.country foreign keys

ALTER TABLE public.country ADD CONSTRAINT country$\_$capital$\_$fkey FOREIGN KEY $($capital$)$ REFERENCES public.city$($id$)$;

CREATE TABLE public.countrylanguage $($

countrycode bpchar$(3)$ NOT NULL,

"language" text NOT NULL,

isofficial bool NOT NULL,

percentage float$4$ NOT NULL,

CONSTRAINT countrylanguage$\_$pkey PRIMARY KEY $($countrycode$,$ language$)$

$)$;

$--$ public.countrylanguage foreign keys

ALTER TABLE public.countrylanguage ADD CONSTRAINT countrylanguage$\_$countrycode$\_$fkey FOREIGN KEY $($countrycode$)$ REFERENCES public.country$($code$)$;

Write a query that returns the following table showing data about two governmental forms $-$ 'Republic' and 'Federal republic. The last column shows the others.

Indicator Federal republic Republic Others

GLE X X X

LLE X X X

GLE $=$ greatest lifetime expectancy

LLE $=$ least lifetime expectancy

X $-$ corresponding calculated value of lifetime expectancy for a particular government form and indicator.

The "Others" column should contain results that relate to all government forms except 'Republic' and 'Federal republic'.

In this task you should use the following operations to prepare a query:

union

order by with limit

filtering in where

Aggregation or window functions should not be used.