Sobes.tech
Intern — Middle

Getting city names along with the names of their inhabitants

livecode

Task condition

Write an SQL query that outputs the name of the city and the name of the user living in that city.

SELECT cities.name AS city_name, users.name AS user_name
FROM users
JOIN cities ON users.city_id = cities.id;