#122 Find Cities Visited by a Passenger

Companies:

Sberbank

Themes:

SQLJoinsPractice

Find every city visited by the passenger named Bruce:

CREATE TABLE Passenger (
    id bigint primary key,
    name text
);

CREATE TABLE Trip (
    id bigint primary key,
    town_to text
);

CREATE TABLE Pass_in_trip (
    id bigint primary key,
    passenger bigint,
    trip bigint,
    foreign key (passenger) references Passenger(id),
    foreign key (trip) references Trip(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.