How to merge two tables that are linked by one another?

Question

MySQL

I'm doing a MySQL lab.
In the first task, you need to display the names of the students and the names of the corresponding streets. It's easy:

SELECT `dannie`.`fam`, `ulica`.`nazvanie` 
FROM `dannie` RIGHT OUTER JOIN `ulica` ON `dannie`.`kod_ulica` = `ulica`.`kod_ulica`

And how to do the second task - display the names of students and the names of the corresponding cities? The corresponding cities (from `gorod`) can be found through the corresponding streets, but I don't understand how to link the tables.

Database Schema:

Answer 1

Joint 3 tables. Use the city id field from the street table for the city table join.