When I Go to start the program to get the information, it is not loading the data at all. It is acting like it is not se

[answerhappygod]

When I Go to start the program to get the information, it is notloading the data at all. It is acting like it is not seeing thedata when I know I am pulling from the correct database. Am I doingsomething within the code? Thank you for the help
Best SF? -------- Find the top rated family safe sci fi shows inthe SHOW table. Include all shows where the Genre is sci fi, theStarRating is 8 or over, and the Classification is either G, PG, orPG-13. Use IN with a set of values to match the Classification.Produce the following columns: Title, Description, StarRating,Classification. Title should be no more than 20 characters wide andDescription should be no more than 50 characters wide.Classification should be no more than 5 characters wide. Don''tforget to give all columns names! Order in descending order by starrating. For shows with the same star rating, order by titlealphabetically (A-Z). Hint: Use the results in the previous queryto determine the correct spelling for the sci fi genre. Hint 2:Correct results will have 24 rows and will look like this (I did abit of minor editing because of apostrophes): Title DescriptionStarRating Classification ---------------------------------------------------------------------- ------------------------- Avatar On an alien planet, a former Marine (SamWorthingt 10 PG-13 Gravity The destruction of their shuttle leavestwo astron 10 PG-13 Minority Report A policeman (Tom Cruise) triesto establish his in 10 PG-13 Star Wars: The Force Thirty yearsafter the defeat of the Galactic Empi 10 PG-13 The Day the Earth StKlaatu (Michael Rennie) and his guardian robot, Go 10 G Dawn of thePlanet o Human survivors of a plague threaten Caesar''s gro 8 PG-13Fantastic Planet The 39-foot-tall pastel Draags keep leashes on the8 PG Gattaca An outcast (Ethan Hawke) takes part in a complicat 8PG-13 Guardians of the Gal A space adventurer (Chris Pratt) becomesthe quarr 8 PG-13 I Am Legend After a man-made plague transformsEarth''s popula 8 PG-13 Independence Day A fighter pilot (WillSmith), a computer whiz (Jef 8 PG-13 Interstellar As mankind''stime on Earth comes to an end, a gro 8 PG-13 Invasion of the BodySan Francisco health inspectors (Donald Sutherland 8 PG MidnightSpecial The government and a group of religious extremists 8 PG-13Pacific Rim A washed-up ex-pilot (Charlie Hunnam) and an untes 8PG-13 Rise of the Planet o A scientist''s (James Franco) quest tofind a cur 8 PG-13 Serenity Crew members (Nathan Fillion, GinaTorres, Alan Tu 8 PG-13 Solaris A widowed psychologist (GeorgeClooney) arrives at 8 PG-13 The Abyss Oil-platform workers,including an estranged coupl 8 PG-13 The Fifth Element A New YorkCity cabdriver (Bruce Willis) tries to 8 PG-13 The Hunger Games Aresourceful teen (Jennifer Lawrence) takes her y 8 PG-13 The HungerGames: Ca After their unprecedented victory in the 74th Hung 8PG-13 Twilight Zone: The M Four tales include a bigot (Vic Morrow),oldsters 8 PG Westworld Androids go haywire with guests (RichardBenjamin, 8 PG ' + CHAR(10) GO
-- -- [Insert your code here] --
SELECT SUBSTRING(Title,1,20) AS 'Title',
SUBSTRING(Description, 1,50) AS 'Description',
StarRating,
SUBSTRING(Classification, 1,5) AS 'Classification'
FROM SHOW
WHERE Genre = 'sci fi' AND StarRating >= 8 AND ClassificationIN ('G', 'PG', 'PG-13')
ORDER BY StarRating DESC, Title ASC;