subject

Hello I am super stuck with these questions if anyone can help me that would be great. The lab is asking to create the answer using SQL. PRINT 'CIS 275, Lab Week 2, Question 8 [3pts possible]:Rick and MortyShow a distinct list of all Rick and Morty episodes in the SHOW table. Include the following columns:Title - 20 wide. Episode - 20 wide. Series # - 10 wide. Episode # - 3 wide. Original Air Date - 12 wide, formatted as, for example, "Apr 01, 2017".Display results in order by episode number. Correct results will look like this:Title Episode Series # Episode # Original Air Date Rick and Morty The Rickshank Rickde EP01833673 301 Apr 01, 2017Rick and Morty Rickmancing the Ston EP01833673 302 Jul 30, 2017Rick and Morty Pickle Rick EP01833673 303 Aug 06, 2017Rick and Morty Vindicators 3: The R EP01833673 304 Aug 13, 2017Rick and Morty The Whirly Dirly Con EP01833673 305 Aug 20, 2017Rick and Morty Rest and Ricklaxatio EP01833673 306 Aug 27, 2017Rick and Morty The Ricklantis Mixup EP01833673 307 Sep 10, 2017' + CHAR(10)GO [Insert your code here]--GOPRINT 'CIS 275, Lab Week 2, Question 9 [3pts possible]:Couch Potato AchievementProduce a list of the 10 longest shows. Exclude sports-related genres and shows where the titleis "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:00BBCAPH Doctor Who Deep Breath Sep 08, 2017 12:30:00 - 20:30:00 08:00:00BBCAPH Doctor Who Deep Breath Sep 08, 2017 20:30:00 - 04:30:00 08:00:00CSPAN2 Public Affairs Event N/A Sep 08, 2017 21:00:00 - 05:00:00 08:00:00CSPAN2 Book TV N/A Sep 10, 2017 10:00:00 - 18:00:00 08:00:00BBCAP Doctor Who Deep Breath Sep 08, 2017 04:30:00 - 12:30:00 08:00:00BBCAP Doctor Who Deep Breath Sep 08, 2017 12:30:00 - 20:30:00 08:00:00BBCAP Doctor Who Deep Breath Sep 08, 2017 20:30:00 - 04:30:00 08:00:00TVMRT Beyond Today N/A Sep 03, 2017 19:30:00 - 03:30:00 08:00:00TVMRT Beyond Today N/A Sep 04, 2017 03:30:00 - 11:30:00 08:00:00Hint: Use ISNULL to display NULL values in Episode as N/A, and restrict them to no more than 20characters wide.' + CHAR(10)GO [Insert your code here]--GOPRINT 'CIS 275, Lab Week 2, Question 10 [3pts possible]:It''s a Good LifeFind all showings of The Twilight Zone episode "It''s a Good Life." Format your results exactlyas they appear below. Hint: You can convert the same DATETIME twice, using two different format codes, and concatenate theresults together into a single string. Correct output will look like this (only two columns):Channel Name Time SYFYP Sep 15, 2017: 06:00:00 - 06:30:00SYFYHDP Sep 15, 2017: 06:00:00 - 06:30:00SYFYP Sep 16, 2017: 05:00:00 - 05:30:00SYFYHDP Sep 16, 2017: 05:00:00 - 05:30:00' + CHAR(10)GO [Insert your code here]--GO

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 10:30
Auniversity wants to install a client-server network. which feature do you think is important for them as they set up the network? sending email blocking multiple people to use the same file low security low set up cost limited access to files
Answers: 1
question
Computers and Technology, 22.06.2019 14:30
The β€œrule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)
Answers: 1
question
Computers and Technology, 24.06.2019 02:00
What is a loop? a. a collection of function definitions at the top of a program b. a line of code that defines a variable and assigns it a value c. a program that opens the turtle graphics window d. a block of code that repeats a specific number of times
Answers: 1
question
Computers and Technology, 24.06.2019 11:30
What does the https: // mean when you type in a website
Answers: 1
You know the right answer?
Hello I am super stuck with these questions if anyone can help me that would be great. The lab is as...
Questions
question
Mathematics, 04.09.2020 22:01
Questions on the website: 13722367