<reponame>KostadinovK/CSharp-DB
SELECT TOP(50)
	e.FirstName, e.LastName, t.[Name], a.AddressText
FROM Employees e
JOIN Addresses a ON e.AddressID = a.AddressID
JOIN Towns t ON a.TownID = t.TownID
ORDER BY FirstName, LastName;