In this scenario, our CEO has learned to perform basic SQL selects in the database, needs help with more complex ones. To help her, we will create SQL views that answers several requests for data found in the Northwind database. Your project manager has volunteered you to create these views! He has emailed her saying they are complete, but you still have not made them! You have better get busy and get them in place! Tip: You can use the provide SQL file, Assignment04.sql, to get you started. Step 1: Review the letter the PM is sending "Hello, Jane! I have created the following views to help get the information you have requested in the past. Data Request: 0301 Request: I want a list of customer companies and their contact people Select *from vCustomerContacts -Data Request: 0302 -Request: I want a list of customer companies and their contact people, but only the ones in US and Canada In this scenario, our CEO has learned to perform basic SQL selects in the database, needs help with more complex ones. To help her, we will create SQL views that answers several requests for data found in the Northwind database. Your project manager has volunteered you to create these views! He has emailed her saying they are complete, but you still have not made them! You have better get busy and get them in place! Tip: You can use the provide SQL file, Assignment04.sql, to get you started. Step 1: Review the letter the PM is sending "Hello, Jane! I have created the following views to help get the information you have requested in the past. Data Request: 0301 Request: I want a list of customer companies and their contact people Select *from vCustomerContacts -Data Request: 0302 -Request: I want a list of customer companies and their contact people, but only the ones in US and Canada