Question: Repeat the previous query, except this time use a CROSS JOIN. Add a WHERE clause that matches display names that end in P with display
Repeat the previous query, except this time use a CROSS JOIN. Add a WHERE clause that matches display names that end in P with display names that end in HDP Note: There are ways to do this that don' \"t require a CROSS JOIN, but use a CROss JOIN anyway Hint: The function LEFT will return the left part of a string. For example, given a column like \"Animal\", with a value like \"fruitbat\", the function LEFT(Animal, 5) will return the value \"fruit\". The function RIGHT (Animal, 3) will return the value \"bat\". The function LEN(Animal) will return 8 Hint 2: The correct answer will look like this: Standard Channel Standard Name HD Channel HD Name AETVP APLP CMTVP DISNP DSCP DXDP HBOP MAXP SHOWP 1402 1471 1625 1608 1715 1449 1716 1803 1821 1841 AETVHDP APLHDP BETHDP CMTVHDP DISNHDP DSCHDP DXDHDP HBOHDP MAXHDP SHOWHDP 43 56 41 7 122 551 561 576
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
