SQLize Online / PHPize Online  /  SQLtest Online

create table street ( id serial primary key, title varchar ); create table resident ( id serial primary key, name varchar, fortune bigint, street_id int, constraint fk_resident_street foreign key (street_id) references street(id) ); insert into street (title) values ('first'), ('second'), ('third'), ('fourth'); insert into resident (name, fortune, street_id) values ('Kate', 10, 1), ('John', 100, 1), ('Serg', 200, 2), ('Ann', 20, 2), ('Helen', 30, 3), ('Mik', 400, 4); -- вывести самого богатого жителя на каждой улице(имя, деньги, название улицы) select name from resident where fortune in (select max(fortune) from resident group by street_id)