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;