SELECT FullName FROM
(
SELECT
FullName = LastName + ‘, ‘ + FirstName
FROM Employees
) sub
WHERE sub.FullName = ‘Bertrand, Aaron’
sql for everyone
SELECT FullName FROM
(
SELECT
FullName = LastName + ‘, ‘ + FirstName
FROM Employees
) sub
WHERE sub.FullName = ‘Bertrand, Aaron’