Coleman University

  SQL and Database Design

   Practical Application 4:

  Based upon the lecture and lab information, perform several queries on your Northwoods database.

  Below, I have selected some query examples.

• Write a query that will display teachers who are an advisor and are also a professor.
• Write a query that will display students residing on Seaview Lane.
• Write a query that will display teachers who are an advisor and not a professor.
• Write a query that will display students with an advisor.