Junior — Senior
Counting the number of available interviewers by interview types
livecode
Task condition
There is a database consisting of three tables. It is necessary to output a list of interviews and the number of interviewers who can conduct them, considering only the interview types "Java", "JavaScript", "Frontend".
create table INTERVIEW_TYPES
(
id int auto_increment primary key,
name varchar(255) not null,
constraint INTERVIEW_TYPES_name_uindex unique (name)
);
create table INTERVIEWERS
(
id int auto_increment primary key,
name varchar(255) not null,
constraint INTERVIEWERS_name_uindex unique (name)
);
create table INTERVIEWERS_INTERVIEW_TYPES
(
interview_id int not null,
interviewer_id int not null,
constraint INTERVIEWERS_INTERVIEW_TYPES_interview_id_interviewer_id_uindex unique (interview_id, interviewer_id)
);