What are the first names and last names of the employees who live in Calgary city.
SELECT FirstName ,  LastName FROM EMPLOYEE WHERE City  =  "Calgary"
employees who live in Calgary city refers to WHERE City = 'Calgary'; first names and last names refers to SELECT FirstName, LastName;