Question
Produce a list of the 10 longest shows. Exclude sports-related genres and shows where the title is To Be Announced or SIGN OFF. Format your
Produce a list of the 10 longest shows. Exclude sports-related genres and shows where the title is "To Be Announced" or "SIGN OFF". Format your results to look like this:
Channel Name Title Episode Date Time Length ------------ -------------------- -------------------- ------------ ------------------- -------- BBCAPH Doctor Who Deep Breath Sep 08, 2017 04:30:00 - 12:30:00 08:00:00 BBCAPH Doctor Who Deep Breath Sep 08, 2017 12:30:00 - 20:30:00 08:00:00 BBCAPH Doctor Who Deep Breath Sep 08, 2017 20:30:00 - 04:30:00 08:00:00 CSPAN2 Public Affairs Event N/A Sep 08, 2017 21:00:00 - 05:00:00 08:00:00 CSPAN2 Book TV N/A Sep 10, 2017 10:00:00 - 18:00:00 08:00:00 BBCAP Doctor Who Deep Breath Sep 08, 2017 04:30:00 - 12:30:00 08:00:00 BBCAP Doctor Who Deep Breath Sep 08, 2017 12:30:00 - 20:30:00 08:00:00 BBCAP Doctor Who Deep Breath Sep 08, 2017 20:30:00 - 04:30:00 08:00:00 TVMRT Beyond Today N/A Sep 03, 2017 19:30:00 - 03:30:00 08:00:00 TVMRT Beyond Today N/A Sep 04, 2017 03:30:00 - 11:30:00 08:00:00
Hint: Use ISNULL to display NULL values in Episode as N/A, and restrict them to no more than 20 characters wide.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started