Question: You are analyzing operations at a car dealership. Your database has 2 tables . The first is weekly _ sales. In the weekly _ sales
You are analyzing operations at a car dealership. Your database has tables The first is "weeklysales". In the weeklysales table, there is a salesperson IDsalesperson name, week number and the total amount of sales for that week. The second table is called 'orders'. The orders table contains ordernumber, date DDMMYYYY formatcustomer IDSalesperson IDand vehicle IDVehicle ID indicates the Vehicle Identification Number VINof the vehicle that was sold in that order.
Which query below will return the list of vehicle IDs purchased by customer ID in Week Assume that weeks are numbered sequentially according to their calendar date.
Select customerID vehicleID date
From Orders
Where customernumber ;
Select SalespersonID customerID OrderNumber
From Orders
Group By SalespersonID SalespersonName;
Select customerIDvehicleID week
From Orders
Where week ;
Select customerID vehicleID date
From Orders
Where customerID And date Between and ;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
