PRINT Lab Week 2, Question 1 What channel is SYFY? --------------------- Write a SELECT statement that finds the channels named SYFYP and SYFYHDP in the CHANNEL table of the TV database. Use a WHERE clause with an OR statement to return only these two channels. Display only the ChannelNumber and DisplayName columns. Hint: Correct results will look like this (note that DisplayName is 200 characters wide, so I''ve edited a bit): ChannelNumber DisplayName ------------- ----------- 59 SYFYP 1411 SYFYHDP ' + CHAR(10) GO -- -- [Insert your code here] --

PRINT Lab Week 2, Question 2: What channel is OPB? --------------------- Write a SELECT statement that finds all the channels with OPB in the display name. Use a WHERE clause with LIKE and wildcards to find all matching channels. Display only the ChannelNumber and DisplayName columns. This time, use CONVERT to make the DisplayName be 10 characters wide. Use AS to give your column a name. Display results in ascending order by ChannelNumber. Hint: Correct results will look like this: ChannelNumber ChannelName ------------- ----------- 10 KOPB 1010 KOPBDT 1165 KOPBDT2 1166 KOPBDT3 ' + CHAR(10) GO -- -- [Insert your code here] -- 

using Microsoft SQL Server Management Studio 2012 (or later)

or DataGrip