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, 23.06.2019 15:00
Based on the current economic situation do you expect the employment demand for graduating engineers to increase or decrease? explain the basis for your answer. with a significant economic recovery, what do you think will happen to future enrollments in graduating engineering programs?
Answers: 1
question
Computers and Technology, 23.06.2019 22:30
Lakendra finished working on her monthly report. in looking it over, she saw that it had large blocks of white space. what steps could lakendra take to reduce the amount of white space?
Answers: 3
question
Computers and Technology, 24.06.2019 03:30
Which explains extrinsic motivation? a)motivation in which there is a reward b)motivation that is personally satisfying c)motivation that is personally meaningful d)motivation in which the subject is interesting
Answers: 1
question
Computers and Technology, 24.06.2019 21:30
How is a wan different than a lan? both connect computers, but only wan users don’t need the same operating system. both are peer-to-peer networks, but only a wan requires networking hardware. both network computers, but only a wan can cover larger geographical ranges. both connect computers to the internet, but only wan connects to the cloud.
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