• 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

There are two tables, #People and #Pets. Assuming the tables had the following values:

#People ID FirstName LastName 1 Timothy Khouri 2 Bob Dole 3 Bobby McGee

#Pets ID PeopleID Kind Name 1 1 Cat Sophie 2 2 Goldfish Goldie 3 2 Dog Spot

... write a query that will yield the following results:

#Sample Result

FirstName	LastName	PetCount
Bob	Dole	2
Timothy	Khouri	1

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