Given the Offices and Cities tables that are connected by city_id and containing following data in them:
Offices
|----------------------|
|office_id|name|city_id|
|----------------------|
|        1|of1 |     22|
|        2|of2 |      3|
|        3|of3 |      7|
|----------------------|

Cities
|------------------|
|city_id|   name   |
|------------------|
|      3|   Kyiv   |
|     22|   London   |
|     25| Bangkok |
|------------------|
Which of the following queries will return 3 records in a result set?

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback