Junior — Senior
Getting departments where only men rated above five
livecode
Task condition
There is a table evaluations. Without using JOINs and nested queries, it is necessary to output all department identifiers where only male respondents are present and each of them has given a score strictly greater than 5.
evaluations.sql
create table evaluations
(
respondent_id uuid primary key, -- Respondent ID
department_id uuid, -- Department ID
gender boolean, -- true — male, false — female
value integer
);