HD Stations ----------- Select the DisplayName and SortOrder from the CHANNEL table for all TV channels where the SortOr
Posted: Sun Jul 03, 2022 12:01 pm
HD Stations-----------Select the DisplayName and SortOrder from the CHANNEL table for allTV channels where the SortOrder isbetween 700 and 799 inclusive. Use the BETWEEN ... AND ...operator. Exclude all rows where the ExternalIDis NULL. Use "Channel Name" as the header for the name column and"Sort Order" for the sort order column.Display results in ascending order by SortOrder.
Hint: The correct answer will have 93 rows and will look likethis:
Channel Name Sort Order------------ -----------KATUDT 702KRCWDT 703KPXGDT 705KOINDT 706DSCHDP 707KGWDT 708WGNAPHD 709KOPBDT 710VEL 711KPTVDT 712KPDXDT 713FUSEHD 714...UPHD 797AXSTV 798NFLNRZD 799
Hint: The correct answer will have 93 rows and will look likethis:
Channel Name Sort Order------------ -----------KATUDT 702KRCWDT 703KPXGDT 705KOINDT 706DSCHDP 707KGWDT 708WGNAPHD 709KOPBDT 710VEL 711KPTVDT 712KPDXDT 713FUSEHD 714...UPHD 797AXSTV 798NFLNRZD 799