This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SQL (203 exercises)
Topic ==>	Views (7 exercises)
Level ==>	Harder than average
Subject ==>	SQL training

Use views based on views to show Doctor Who episodes with only 1 enemy and 1 companion

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

If you haven't already done so, run the script in the above folder to generate the Doctor Who database.

Create a series of views which will ultimately list out all of the episodes which had both multiple enemies and multiple companions.

There are many ways to do things like this in SQL, and the method in this exercise is a long way from being the most efficient!

To achieve this, create (in this order) the following views:

View	What it must do
vwEpisodeCompanion	Llist all of the episodes which had only a single companion.
vwEpisodeEnemy	List all of the episodes which had only a single enemy.
vwEpisodeSummary	List all of the episodes which have no corresponding rows in either the vwEpisodeCompanion or vwEpisodeEnemy tables.