You are analyzing operations at a car dealership. Your database has $2$ tables. 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 best $($maximum$)$ single weekly sales for each of your salespeople.?

$-$Select Salesperson$\_$ID$,$Salesperson$\_$Name, Max$($Sales$)$

From weekly$\_$sales

$-$Select Salesperson$\_$ID$,$ Salesperson$\_$Name, Max$($Sales$)$

From Orders

Group By Salesperson$\_$ID$,$ Salesperson$\_$Name;

$-$Select Salesperson$\_$ID$,$Salesperson$\_$Name, Max$($Sales$)$

From weekly$\_$sales

Group By Salesperson$\_$ID$,$ Salesperson$\_$Name;

$-$Select Salesperson$\_$ID$,$Salesperson$\_$Name, Order$\_$number, Max$($Sales$)$

From Sales$\_$Table, Orders

Group By Week$\_$Number;