Activity 7
The business users have been complaining that while they are able to see the sales data and see customer_id values in the sales table, they have to pull data from the customers table with an ID filter to see the customer name. Can you run a query to return all columns of the customers table and the sales table combined, based on the criteria that the records from the two tables belong to the same customer?
Now that the users can see each customer’s name with the sales figure, they want to see the columns from the customers table, products table, and sales table using one query. You should return all columns of the three tables.
It is known that internet sales do not have associated dealerships. To get a comprehensive view of sales, the business users want to see all columns from the sales table, together with all the columns from the dealerships table, if the sales belong to a certain dealership.
