SQL 1. Write a JOIN between these two tables that shows Purchases and Cost Per Purchase...

Transcribed Image Text:

SQL 1. Write a JOIN between these two tables that shows Purchases and Cost Per Purchase for each row of Table [Spend_table]. Write your 1) SQL Statement and 2) show the end table. [Spend_table] Date 10/1/2020 10/1/2020 10/1/2020 10/2/2020 [Conversions_table] Date 10/1/2020 10/1/2020 10/1/2020 10/1/2020 10/2/2020 Campaign Name Campaign A Campaign A Campaign A Campaign B Device Type Mobile Desktop Desktop Tablet Desktop Campaign Name Device Type Campaign A Desktop Campaign A Desktop Campaign A Mobile Campaign A Tablet Campaign B Lead Purchase Spend 100 Lead Lead 150 Conversion Type Conversions Purchase 100 100 1 1 2 1 3 2. What would you do differently if Device Type was missing from [Spend_table]? 3. How would you achieve the same result of Question 1 but with a UNION instead of a JOIN? 4. Let's say you need to SUM 3 numerical columns on a table, but one has NULLs in it; how would you proceed without editing the table? SQL 1. Write a JOIN between these two tables that shows Purchases and Cost Per Purchase for each row of Table [Spend_table]. Write your 1) SQL Statement and 2) show the end table. [Spend_table] Date 10/1/2020 10/1/2020 10/1/2020 10/2/2020 [Conversions_table] Date 10/1/2020 10/1/2020 10/1/2020 10/1/2020 10/2/2020 Campaign Name Campaign A Campaign A Campaign A Campaign B Device Type Mobile Desktop Desktop Tablet Desktop Campaign Name Device Type Campaign A Desktop Campaign A Desktop Campaign A Mobile Campaign A Tablet Campaign B Lead Purchase Spend 100 Lead Lead 150 Conversion Type Conversions Purchase 100 100 1 1 2 1 3 2. What would you do differently if Device Type was missing from [Spend_table]? 3. How would you achieve the same result of Question 1 but with a UNION instead of a JOIN? 4. Let's say you need to SUM 3 numerical columns on a table, but one has NULLs in it; how would you proceed without editing the table?