Computers and Technology

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

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 11:30, neekWYB
Andrina writes letters that are regularly sent to hundreds of her company’s customers. because of this, she would like for the mail merge command to be in her quick access toolbar, and she wants it to be the first button on the left. what should andrina do to place the mail merge button there?
Answers: 1
image
Computers and Technology, 23.06.2019 07:30, devnnn44
What is the original authority for copyright laws
Answers: 1
image
Computers and Technology, 23.06.2019 15:30, Dweath50
The processing of data in a computer involves the interplay between its various hardware components.
Answers: 1
image
Computers and Technology, 23.06.2019 15:30, taapeters
Brian wants to conduct an online search with a certain phrase. he intends to use the words books that belong to the 1800s in his search. how should he use the word that in his search?
Answers: 1
Do you know the correct answer?
Hello I am super stuck with these questions if anyone can help me that would be great. The lab is as...

Questions in other subjects:

Konu
Spanish, 10.04.2021 20:20
Konu
Mathematics, 10.04.2021 20:20