Question

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

Answer 1

The queries for the questions are given below-

ANSWER 1
===========

SELECT ChannelNumber, DisplayName
FROM CHANNEL
WHERE DisplayName = "SYFYP" OR DisplayName = "SYFYHDP"

ANSWER 2
=========
SELECT ChannelNumber, CONVERT(VARCHAR(10), DisplayName) AS ChannelName
FROM CHANNEL
WHERE DisplayName LIKE "%OPB%"
ORDER BY ChannelNumber