#368 Students from Universities with a Matching Name

Companies:

VTB

Themes:

SQLJoinsPractice

Write a query that displays student names and the names of the universities where they study, provided that the university name starts with the letter "C":

Table student:
id | name
...

Table univer_student:
student_id | univer_id
...

Table univer:
id | name
...

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.