Queries Cursors Views
Sql Query Basics
Full Text Searching
Using subqueries - Exercise
Creating and using subqueries in SQL-Server
Practice creating a subquery.
This exercise is worth a total of 20 points. You will receive up to 20 points for accurately creating the subquery as described in the instructions.
Consider the following table, named Division:
Now consider the following table, named Employee:
Write a subquery that will select only the DivisionName from the Division table for all employees that have a PayGrade of B in the Employee table.
Make sure that you use an IN clause and not join the two tables together.
Submitting the exercise
Type or paste your Transact-SQL statement into the text box below, then click
to submit them and view a results page.