• Home
• Developers
• Recruiters
• My Account
• Contact Us

• C#
  • Hello World
  • Basic Language Skills, part 1
  • Basic Language Skills, part 2
  Level 2
  • Code Concepts, Recursion
  • Optimize Code, part 1
  • Optimize Code, part 2
  • Multi Threading, part 1
  • Transactions, part 1
  Level 3
  • Algorithms, Standard Deviation
  • Optimize Code, part 3
  • Algorithms, Brute Force
  • Code Concepts, Recursion 2
  • Transactions, part 2
• JavaScript
  • Basic JavaScript, part 1
  • Basic JavaScript, part 2
  • Simple For Loop
  Level 2
  • Basic AJAX, part 1
• Network Development
  • Host a TCP Connection
  • Send and Recieve over TCP
  Level 2
  • Data Transmit Spec
  Level 3
  • MultiUser TCP Chat Server
• Transact-SQL (MSSQL)
  • Basic SQL, querying
  • Basic SQL, filtering
  • Basic SQL, joining
  Level 2
  • Aggregate Counts
  • Query XML in SQL
  Level 3
  • Advanced Debugging, part 1
• Web Development
  • Host a Public Website
  • Echo Test
  • Echo With Loop
  • Echo With XML Input
  • Input Validation, part 1
  Level 2
  • RESTful Web Service
• XML
  • Define a person in XML
  • Basic XPath
  • Basic XPath, part 2
  Level 2
  • Basic XSL Transformation

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 query the table, excluding the ID column. The results should be ordered by LastName.

In order to take this test you must first sign in.