#487 Row Count for Different JOIN Types

Companies:

Ozon

Themes:

SQLJoinsCode Review

There are two tables:

- tab1
id
1
2
3

- tab2
id
1
1
2
2

State the number of rows in the resulting table for:

inner join
left join
cross join

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.