Please write DDL and not narrative. here is my guess at what you are
trying to do. What you posted was not a table because you had no key.TEXT is not the datatype to use for names --
unlessthey are thousand
of characters long!!
Recording age as an integer is useless -- give us the birthday and we
can always compute their age. Is this what you meant to post?
CREATE TABLE People
(name CHAR(30) NOT NULL PRIMARY KEY, -- not big enough for TEXTage INTEGER NOT NULL, -- should be birthdate
insteadcompanyCHAR(30) NOT NULL);
>> ... create a query than get me a list with the seniors per company,
for example :<<
SELECT P1.name, P1.age, P1.company FROM People AS P1WHERE NOT EXISTS (SELECT * FROM People AS P2
WHEREP1.company = P2.company AND P1.age < P2.age);
This says there is nobody older than the P1 person in the same
company.