Database: chinook_1
Question: What are the first names and last names of the employees who live in Calgary city.
SQL:
SELECT FirstName ,  LastName FROM EMPLOYEE WHERE City  =  "Calgary"