Sobes.tech
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
);