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 2tables. The first is "weekly_sales". In the weekly_sales table, there is a salesperson ID,salesperson name, week number and the total amount of sales for that week. The second table is called 'orders'. The orders table contains order_number, date (DD-MM-YYYY format),customer ID,Salesperson ID,and vehicle ID.Vehicle ID indicates the Vehicle Identification Number (VIN)of the vehicle that was sold in that order.
Which query below will return the list of vehicle IDs purchased by customer ID 53 in Week 1? Assume that weeks are numbered sequentially according to their calendar date.
-Select customer_ID, vehicle_ID, date
From Orders
Where customer_number ='53';
-Select Salesperson_ID, customer_ID, Order_Number
From Orders
Group By Salesperson_ID, Salesperson_Name;
-Select customer_ID,vehicle_ID, week
From Orders
Where week ='1';
-Select customer_ID, vehicle_ID, date
From Orders
Where customer_ID ='53' And date Between 01-01-2018 and 07-01-2018;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!