a$.$ Run an SQL query to determine ZoomZoom$$s total sales amount for each state

$($Hint: join the sales and customers tables and use the SUM aggregate function$).$

Exclude sales where the state is not known and ensure that your query rounds the

total sales amounts to the nearest penny $($two decimals$).$ Order the results by total

sales amount, from highest to lowest. Provide the text of your SQL query, the

names and total sales amounts for the seven states with the highest total sales

amounts, and the seven states with the lowest total sales amounts.

b$.$ Run an SQL query to determine ZoomZoom$$s two product types. Provide the

text of your SQL query and the names of the two product types.

c$.$ Run an SQL query to determine ZoomZoom$$s total sales amount for scooters

from each state $($Hint: join the sales, products and customers tables and use the

SUM aggregate function$).$ Exclude sales where the state is not known and ensure

that your query rounds the total sales amounts to the nearest penny $($two

decimals$).$ Order the results by total sales amount, from highest to lowest.

Provide the text of your SQL query, the names and total sales amounts for

the seven states with the highest total sales amounts $($for scooters only$),$ and

the seven states with the lowest total sales amounts $($for scooters only$).$

d$.$ Run an SQL query to determine ZoomZoom$$s total sales amount for cars from

each state $($Hint: join the sales, products and customers tables and use the SUM

aggregate function$).$ Exclude sales where the state is not known and ensure that

your query rounds the total sales amounts to the nearest penny $($two decimals$).$

Order the results by total sales amount, from largest to smallest. Provide the text

of your SQL query, the names and total sales amounts for the seven states

with the highest total sales amounts $($for cars only$),$ and the seven states with

the lowest total sales amounts $($for cars only$)$