Question: Run Time Minutes - - - - - - - - - Write a SQL subquery to find the primary titles of the records whose

Run Time Minutes
---------
Write a SQL subquery to find the primary titles of the records whose
runtime minutes are more than the average runtime minutes.
Return Primary Title and Runtime Minutes.
Use only SUBQUERIES and no JOINS. Do not hard-code any strings from the results.
You will be using IMDB database.
There will be 537,945 rows if you eliminate duplicates.
Format the output with proper names.
The correct answer will look like:
Primary Title Run Time Minutes
----------------------------------------------------------------------------------------------------------
----80
' AV muri' Fukada Nana 107 cmK kappu gingakei saikyo oppai muchakucha damashi momi 120
' Horse Trials '120
!Women Art Revolution 83
"All in the Family" Retrospective 90
"Are They All Yours?" Live Q & A 72
"Bort g de, stumma skrida de..."49
...
ZZ Top: Live at Montreux 201381
ZZ Top: Live from Texas 122
Zzim 101
ZZonk!! Splatt!!- the World of Children's Comics 50
ZZZZZ 51

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!