Question $2$

Instructions

Click on the button below to load the Auntie B Database.

LOAD AUNTIE B$\text{'}$S DATABASE

Read the problem listed below and construct your query in the window in the top left. Before clicking on the Check It button click on the Try IT button and compare the output your query is generating versus the answer output. If both match, click on the Check It$!$ button to grade your query.

This question is worth $2$ points.

Problem

Using a subquery create a query that will display the fist and last name of the employee who took orders for Toys. Additionally restrict your output to show those toys that have a price less than the highest minimum price listed in the Item table. Rename your columns First Name, Last Name, Name and Price. Sort your output by the Item Type Name.

Your output should look like the table below.

First Name Last Name Name Price

$--------------------------------------------------------------$

Ben Axch Toys Baby $6\mathrm{.}50$

Judy Barney Toys Baby $10\mathrm{.}50$

Judy Barney Toys Baby $3\mathrm{.}50$

Judy Barney Toys Baby $5\mathrm{.}00$

Kemson Brian Toys Baby $12\mathrm{.}00$

Rose Miller Toys Baby $5\mathrm{.}00$

Audrey Ropeburn Toys Child $15\mathrm{.}00$

Audrey Ropeburn Toys Child $7\mathrm{.}00$

Audrey Ropeburn Toys Child $9\mathrm{.}00$

Althea Timothy Toys Toddler $10\mathrm{.}50$

Rose Miller Toys Toddler $8\mathrm{.}00$

Audrey Ropeburn Toys Toddler $4\mathrm{.}00$

Audrey Ropeburn Toys Toddler $5\mathrm{.}00$

$(13$ rows affected$)$