Using the sqla database, connect the sales and customers databases to obtain a list of customers who bought a car.Submit a Word document with the results of the successful query.

Exercise 10: USING JOINS
Using the sqla database, connect the sales and customers databases to obtain a list of customers who bought a car.
Submit a Word document with the results of the successful query. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.
If the time and date are not visible, you will be graded 0.
Put the screenshots in a word document, make sure to comment the code (explain what it does) and interpret the graph if applicable(explain what its depicting)
All assignments will go through SafeAssign. Your score should be less than 30 and you will only be allowed 2 attempts.
Please email your instructor if you have any questions.
EXERCISE 11: USING UNION
Using sqlda, do the UNION query described in the text. Submit a Word document with a screenshot of the result. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.
If the time and date are not visible, you will be graded 0.
Put the screenshots in a word document, make sure to comment the code (explain what it does) and interpret the graph if applicable(explain what its depicting)
All assignments will go through SafeAssign. Your score should be less than 30 and you will only be allowed 2 attempts.
Please email your instructor if you have any questions.
EXERCISE 12: CASE STATEMENT
1. using sqlda, create a query that will add a region column to the customer id according to the ranges provided in the text.
Submit a screen shot of the successful query. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.
If the time and date are not visible, you will be graded 0.
Put the screenshots in a word document, make sure to comment the code (explain what it does) and interpret the graph if applicable(explain what its depicting)
All assignments will go through SafeAssign. Your score should be less than 30 and you will only be allowed 2 attempts.
Please email your instructor if you have any questions.
ACTIVITY 5: SALES MODEL
Complete Activity 5 as described in the text. Submit a screen shot of your output. This is a complex query that provides a variety of columns in the result including a new column that identifies the transaction as one of ‘high savings’. What command will you use to accomplish this? Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.
If the time and date are not visible, you will be graded 0.
Put the screenshots in a word document, make sure to comment the code (explain what it does) and interpret the graph if applicable(explain what its depicting)
All assignments will go through SafeAssign. Your score should be less than 30 and you will only be allowed 2 attempts.
Please email your instructor if you have any questions.