• 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 are two tables called #People and #Pets that contains a random amount of records. The table structures are as follows:

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

#Pets TABLE Column DataType Size ID INT 4 PeopleID INT 4 Kind VARCHAR 100 Name VARCHAR 100

Your task is to produce the following table. Notice that some column names have been aliased and some have been combined. Also, it is important that only people with pets are in the resultset.

#Sample Result

HumanID	HumanName	PetID	PetKind	PetName
123	Smith, John	101	Cat	Fluffy
124	Dole, Bob	102	Dog	Spot

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