Schema: CREATE TABLE EMPLOYEE (FirstName VARCHAR, LastName VARCHAR, City VARCHAR)
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"