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, 21.06.2019 23:30
Acomputer is a multipurpose device that accepts input, processes data, stores data, and produces output, all according to a series of stored . the processing unit of most modern computers is a(n) . the instructions that tell a computer how to carry out a task are referred to as computer , which are distributed as software. computers run three main types of software: software, system software, and development tools. an example of system software is a computer system, which is essentially the master controller for all the activities that a digital device performs. digital devices are constructed using tiny electronic components that represent data bits as electrical signals. the system unit houses the system board, which contains several circuits made from semiconducting materials. computers come in three popular form factors: component, , and slate. many of today's digital devices operate on battery power supplied by ion batteries. battery life and lifespan can be extended by following good battery management practices.
Answers: 3
question
Computers and Technology, 22.06.2019 19:40
Solve the following javafx application: write a javafx application that analyzes a word. the user would type the word in a text field, and the application provides three buttons for the following: - one button, when clicked, displays the length of the word.- another button, when clicked, displays the number of vowels in the word.- another button, when clicked, displays the number of uppercase letters in the word(use the gridpane or hbox and vbox to organize the gui controls).
Answers: 1
question
Computers and Technology, 22.06.2019 23:00
Which type of tab stop is most for weights and measurements?
Answers: 1
question
Computers and Technology, 23.06.2019 13:00
Which one of the following voltages should never be measured directly with a vom? a. 1200 v b. 500 v c. 800 v d. 100v
Answers: 2
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, 21.09.2020 04:01
question
Social Studies, 21.09.2020 04:01
question
Mathematics, 21.09.2020 04:01
question
Physics, 21.09.2020 04:01
question
Mathematics, 21.09.2020 05:01
question
Mathematics, 21.09.2020 05:01
Questions on the website: 13722363