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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!