Реализовать запрос в среде InterBase

CREATE TABLE otd
(kod nomer PRIMARY KEY,
naimen stroka);
 
CREATE TABLE pal
(NUMBER nomer PRIMARY KEY,
tel stroka,
kolvo_mest nomer,
kod_otd nomer,
FOREIGN KEY(kod_otd)
REFERENCES otd (kod)
ON UPDATE cascade;

SELECT COUNT (*)
FROM pal
WHERE MAX (SUM(kolvo_mest))
INTO maxmest
 
SELECT o.naimen, MAX(kolvo_mest)
FROM otd o, pal p
WHERE p.kolvo_mest = maxmest;

CREATE VIEW tbl AS
SELECT otd.naimen, SUM(pal.kolvo_mest) AS col
FROM pal
INNER JOIN otd ON otd.kod=pal.kod_otd
GROUP BY  pal.kod_otd
 
SELECT naimen, MAX(col) FROM tbl

CREATE DOMAIN nomer
AS
INTEGER NOT NULL
      CHECK(value>0);
 
CREATE DOMAIN stroka
AS
CHAR(50) NOT NULL;
 
 
CREATE TABLE otd
(kod nomer PRIMARY KEY,
naimen stroka);
 
CREATE TABLE pal
(NUMBER nomer PRIMARY KEY,
tel stroka,
kolvo_mest nomer,
kod_otd nomer,
FOREIGN KEY(kod_otd)
REFERENCES otd (kod)
ON UPDATE cascade;

SELECT o.*, p.kol
  FROM otd o
  JOIN (SELECT kod_otd, SUM(kolva_mest) kol
          FROM pal
         GROUP BY kod_otd
         ORDER BY 2 DESC
          ROWS 1) p ON p.kod_otd=o.kod