Help me with these SQL questions!

Database: AdventureWorksDW Table(s): DimCustomer, FactSurveyResponse Required: Get me a list of customers - first name, last name, English Product Category name and product sub-category name - in FOUR columns. Test the SQL that generates the above data and attach the screenshot showing the complete SQL and portion of the results (like the last assignment) When uploading files, be sure to save the screenshots as Q1, Q2 etc prefixed with your myGatelD (mine will be vraj_q1.jpg, vraj_q2.jpg etc) Database: AdventureWorksDW Table(s): DimEmployee, FactSalesQuota Required: Get me all occurrences of the following data for Stephen Jiang - last name, salesquota, calendar quarter and department name. Test the SQL that generates the above data and attach the screenshot showing the complete SQL and portion of the results (like the last assignment) Database: AdventureWorksDW Table(s): DimCustomer, FactSurveyResponse Required: Get me the first name, last name and email of all customers who have not responded to the survey. Test the SQL that generates the above data and attach the screenshot showing the complete SQL and portion of the results (like the last assignment) When uploading files, be sure to save the screenshots as Q1, Q2 etc prefixed with your myGatelD (mine will be vraj_q1.jpg, vraj_q2.jpg etc) Database: AdventureWorksDW Table(s): DimAccount, FactFinance Required: Get me the account description and account key of accounts that do not appear in the FactFinance table. Test the SQL that generates the above data and attach the screenshot showing the complete SQL and portion of the results (like the last assignment) When uploading files, be sure to save the screenshots as Q1, Q2 etc prefixed with your myGateID (mine will be vraj_q1.jpg, vraj_q2.jpg etc)