Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the following queries will use a subquery to find all of the rows in the track table that has a unit _ price

Which of the following queries will use a subquery to find all of the rows in the track table that has a unit_price of 0.99 and has the length of the song in milliseconds that is longer than the AVG track length of all tracks in the album_id between 5 and 10?
SELECT AVG(milliseconds)
FROM TRACK
WHERE milliseconds >
(SELECT *
FROM track
WHERE album_id BETWEEN 5 AND 10)
AND unit_price =0.99;
SELECT *
FROM TRACK
WHERE milliseconds >
(SELECT AVG(milliseconds)
FROM track
WHERE unit_price =0.99)
AND album_id BETWEEN 5 AND 10;
SELECT *
FROM TRACK
WHERE milliseconds >
SELECT AVG(milliseconds)
FROM track
WHERE album_id BETWEEN 5 AND 10
AND unit_price =0.99;
SELECT *
FROM TRACK
WHERE milliseconds >
(SELECT AVG(milliseconds)
FROM track
WHERE album_id BETWEEN 5 AND 10)
AND unit_price =0.99;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions

Question

Find y' for x + y = 1 and simplify.

Answered: 1 week ago

Question

Evaluate the impact of unions on nurses and physicians.

Answered: 1 week ago

Question

Describe the impact of strikes on patient care.

Answered: 1 week ago

Question

Evaluate long-term care insurance.

Answered: 1 week ago