СА
Если я только что провалил собес - оно и к лучшему.
Size: a a a
СА
AR
SS
МС
SS
AM
OS
OS
A
AP
A
A
A
A
AR
-- what if we want to return the salary too?
> select
> manager.name,
> (select employee.name, employee.salary
> from employee
> where employee.manager = manager.name
> order by employee.salary desc
> limit 1)
> from manager;
ERROR: subquery must return only one column
LINE 3: (select employee.name, employee.salary
^
A
AR
A
Y
A