Using the all_data view in the TV database, find all listings for shows on SYFYHDP that whereon any time on 9/12/2017. Do NOT include shows that end at 00:00:00 on 9/12/2017, or begin at 00:00:00 on 9/13/2017. DO include shows that start before midnight on 9/12 but end after midnight, or start before midnight on 9/12 and end after midnight on 9/13 (see results below if that isn''t clear).

Include the following columns:
Time - formatted exactly as HH:MM:SS - HH:MM:SS for start time - end time.
Title - Limit to 20 characters wide.
Length - formatted exactly as HH:MM:SS.
Description - Limit to 50 characters wide.

Display results in order by start time.

Hint: Visit this page for the section on Date and Time Styles:
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017

Hint 2: To get the Length, subtract the start time from the end time and convert the
result using the appropriate date format.

Hint 3: You can concatenate string values in the SELECT clause by adding them together with +.

Hint 4: Correct results will have 19 rows and will look like this:

Time                Title                Length   Description
------------------- -------------------- -------- --------------------------------------------------
23:00:00 - 01:00:00 Lake Placid          02:00:00 A New York paleontologist (Bridget Fonda) goes to
01:00:00 - 03:00:00 Jeepers Creepers     02:00:00 A cloaked figure (Jonathan Breck) terrorizes two s
03:00:00 - 04:00:00 The Twilight Zone    01:00:00 Mute: Parents raise their daughter (Ann Jillian) w
04:00:00 - 04:30:00 Paid Programming     00:30:00 Paid programming. (HDTV)                          
04:30:00 - 05:00:00 Paid Programming     00:30:00 Paid programming. (HDTV)                          
05:00:00 - 05:30:00 Paid Programming     00:30:00 Paid programming. (HDTV)                          
05:30:00 - 06:00:00 Paid Programming     00:30:00 Paid programming. (HDTV)                          
06:00:00 - 07:00:00 CSI: Crime Scene Inv 01:00:00 19 Down...: When the team discovers a connection b
07:00:00 - 08:00:00 CSI: Crime Scene Inv 01:00:00 One to Go: Grissom announces that he is leaving, w
08:00:00 - 09:00:00 CSI: Crime Scene Inv 01:00:00 The Grave Shift: Dr. Langston's first day on the
09:00:00 - 10:00:00 CSI: Crime Scene Inv 01:00:00 Disarmed & Dangerous: A specialized team of forens
10:00:00 - 11:00:00 CSI: Crime Scene Inv 01:00:00 Deep Fried & Minty Fresh: The team investigates a
11:00:00 - 12:00:00 CSI: Crime Scene Inv 01:00:00 Miscarriage of Justice: As Langston testifies at t
12:00:00 - 14:00:00 Seventh Son          02:00:00 A supernatural champion (Jeff Bridges) has little
14:00:00 - 17:00:00 Need for Speed       03:00:00 Determined to take down his treacherous rival (Dom
17:00:00 - 18:57:00 Lake Placid          01:57:00 A New York paleontologist (Bridget Fonda) goes to
18:57:00 - 21:00:00 Lake Placid 2        02:03:00 A sheriff, a big-game hunter and a wildlife office
21:00:00 - 22:00:00 Face Off: Game Face  01:00:00 Stone Cold Superheroes: The artists create plant-h
22:00:00 - 00:30:00 300                  02:30:00 Sparta's King Leonidas (Gerard Butler) and his ba
' + CHAR(10)

Answer rating: 100% (QA)

Hi thanks for posting questionas you suggest we need to conv... View the full answer