Exercise: Show directors and actors for given string

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.

The answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> SQL  (115 exercises)
Topic ==> Table-valued functions  (6 exercises)
Level ==> Average difficulty
Course ==> Advanced SQL
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create an in-line table-valued function which returns all of the film characters containing a given string of text.  For example:

SQL exercise - Table-valued functions (image 1)

You could use your function to show all of the characters containing BEN

When you run the sample command shown above, for example, you should see:

SQL exercise - Table-valued functions (image 2)

Include the FilmDirectorId column in the results from the function

Now write a SELECT statement which joins the results of your function to the tblDirector table to show the people who have directed films containing characters with particular names!

SQL exercise - Table-valued functions (image 3)

The results for BEN again - Steven Soderbergh dominates!

Save the query containing all of this code as Character search, then close it down.

This page has 0 threads Add post