Can you please answer these

$-1.$ List the customers from Californla who bought red mountain bikes in September $2003.$

$.$Use order date as date bought. Multi$-$color bikes with red are considered red bikes.

$-$s Custemento

lastiane

Firstilame

Modeltype

Colorlist

OrderDate

Salestate

$**=2,$ list the employees who sold race bikes shipped to Wisconsin without the help of a retail store in $2001,$

Salestate ModelType StoreID OrderDate

List all of the $($distinct$)$ rear derallleurs installed on road bikes sold in Florida in $2002.$

ComponentiD Manufacturerliane ProductMumber

$=4,$ Who bought the largest $($frame size$)$ full suspension mountain bike sold in Georgia in $2004?$

$-$Customerin Lastlame Firstlame Modelitype

ManufactureriD Manufacturertlame

What is the most expensive road bike component we stock that has a quantity on hand greater than $200$ units?

$=$ComponentiD ManufacturerName ProductNumber Road Category ListPrice QuantityonHand

$=7.$ Which inventory item represents the most money sitting on the shelf$-$based on estimated cost?

$=-$Inventory value is defined as $[$EstimatedCost$]*[$QuantityOnHand$]$ in Component.

ComponentiD ManufacturenName

ProductNumber Category

Year

Value

$=8.$ What is the greatest number of components ever installed in one day by one employee?

$*=$EmployeeID LastName DateInstalled CountOfComponentio

What was the most popular letter style on race bikes in $2003?$

$=$ LetterStyleID CountofSerialNumber

$5-10.$ Which customer spent the most money with us and how many bicycles did that person buy in $2002?$

a$=$Use $2002$ for both amount spent and number of bikes bought. Use OrderDate when determining year. Use SalePrice as amount spent.

o$-$CustomerID LastName FirstName Number of Bikes Amount Spent

$=11.$ Have the sales of mountain bikes $($full suspension or hard tail$)$ increased or decreased from $2000$ to $2004($by count not by value$)?$

We are looking for any bike with a model type that starts with the word Mountain.

$-$saleyear CountofSerialNumber

$-12.$ Which component did the company spend the most money on in $2003?$

$--$The amount spent on a component is the sum of purchase price $*$ quantity. Note the same component may have been purchased multiple times in a time period,

$-$ComponentID ManufacturerName ProductNumb Category Value

$+13.$ Which employee painted the most red race bikes in May $2003?$

In $8,$ col$20,6\mathrm{.}62$ characters