Transact-SQL (MSSQL) ::

Basic SQL, filtering

+5 Transact-SQL (MSSQL)

For this test, you will need to demonstrate some basic SQL skills. There is a table called #People that contains 5 records. The table structure is as follows:

#People TABLE
Column DataType Size
ID INT 4
FirstName VARCHAR 100
LastName VARCHAR 100

Your task is to select all records from the table, exluding any records with the last name 'MORALES'