Skip to content

SQL101-Homework Assignment #1 Answer Key

2006 January 6
tags:
by Shannon Lowder

As promised, here are my answers to the first homework assignment.  If you have something different, please get in touch with me so we can discuss the differences in our answers.  There is always more than one way to come to the same result in SQL, but I want to make sure you have the fundamentals. These answers have been updated to work with AdventureWorks on 2008R2.

And now: the answers.
1. What query would show me all the records in example.person?

SELECT * FROM Example.Person

2. What query would show me the first name and last name for all records in Person.Contact?

SELECT
       FirstName
     , LastName
FROM Person.Contact

3. Now, starting from the last query, what query would limit the results to just those people with a last name of Sanchez?

SELECT
       FirstName
     , LastName
FROM Person.Contact
WHERE
     LastName = 'Sanchez'

4. Again, using our query to show us first and last name from Person.contact, limit the results to people with a last name starting with c.

SELECT
       FirstName
     , LastName
FROM Person.Contact
WHERE
     LastName LIKE 'c%'

5. Given there are many rows returned by the query you wrote in question 4, limit the results to 10 rows.

SELECT TOP 10
       FirstName
     , LastName
FROM Person.Contact
WHERE
     LastName LIKE 'c%'

There you go!  The answers to the first homework assignment.

One Response leave one →

Trackbacks and Pingbacks

  1. SQL101-Homework Assignment #1 | Shannon Lowder

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS