{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ICA-4-Pen-and-Paper-Query-Exercise.docx

ICA-4-Pen-and-Paper-Query-Exercise.docx - In-class...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
In-class Activity #4: Pen-and-Paper Query Exercise Recall our Housing Authority schema from the last in-class exercise: Assume the database schema is called hdb (for “housing database” – clever!). So, in a query, you’ll reference the Development table as hdb.Development. In groups of two or three, create a single SQL query that answers each question below. Make sure you are only returning the information needed to answer the question (don’t just use SELECT *). 1) Which housing units (by unit number) have more than two bathrooms? 2) What is the birthdate of the resident named Tom Haverford?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}