#439 Folders with AVI Files or No Files

Companies:

MoySklad

Themes:

SQLSubqueriesPractice

Write an SQL query that selects folders containing *.avi files or empty folders:

CREATE TABLE folder (
    id uuid PRIMARY KEY,
    name text NOT NULL
);

CREATE TABLE file (
    id uuid PRIMARY KEY,
    name text NOT NULL,
    folder_id uuid NOT NULL,
    CONSTRAINT fk_file_folder_id FOREIGN KEY (folder_id) REFERENCES folder (id)
);

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.