help $11$ What are the largest amounts for a sale item $($SalePrice $*$ Quantity$)$ made to each customer $($first and last names$)$ during November $2015.$ Name the column MaxAmount. $($Note Join across $3$ tables required here$)$

$```$

SELECT

C$.$FirstName,

C$.$LastName,

MAX$($SI$.$SalePrice $*$ SI$.$Quantity$)$ AS MaxAmount

FROM

Customer C

JOIN

Sale S ON C$.$CustomerID $=$ S$.$CustomerID

JOIN

SaleItem SI ON S$.$SaleID $=$ SI$.$SaleID

WHERE

S$.$SaleDate BETWEEN $\text{'}2015-11-01\text{'}$ AND $\text{'}2015-11-30\text{'}$

GROUP BY

$```$

Record Count: $0$

ERROR $[$HY$000][$Oracle$][$ODBC$][$Ora$]$ORA$-01861$: literal does not match format string

FEEDBACK

$\backslash (0/10\backslash )(0\mathrm{.}0\backslash \%)$

Feedback:

$-$ Ignoring case, "Month" could not be found in the query. $(-1)$

$-$ Ignoring case, "Year" could not be found in the query. $(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows. $(-6)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where MaxAmount$=150.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where MaxAmount$=75\mathrm{.}2.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces a column named FirstName. $(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces a column named LastName. $(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces a column named MaxAmount. $(-1)$

FEEDBACK

$\backslash [$

$0\backslash$text $\{/\}10\backslash$text $\{(0\mathrm{.}0\backslash \%)\}$

$\backslash ]$

Feedback:

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows. $(-4)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}1613\text{'}$ and SaleID$=\text{'}193580\text{'}$ and SumSaleAmt$=\text{'}65\mathrm{.}51.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}11492\text{'}$ and SaleID$=\text{'}193581\text{'}$ and SumSaleAmt$=\text{'}484\text{'}.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}5286\text{'}$ and SaleID$=\text{'}193582\text{'}$ and SumSaleAmt$=\text{'}32\mathrm{.}75\text{'}.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}7722\text{'}$ and SaleID$=\text{'}193583\text{'}$ and SumSaleAmt$=\text{'}45\mathrm{.}58\text{'}.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}7367\text{'}$ and SaleID$=\text{'}193584\text{'}$ and SumSaleAmt$=\text{'}356\mathrm{.}17\text{'}.(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where CustomerID$=\text{'}3039\text{'}$ and SaleID$=\text{'}193585\text{'}$ and SumSaleAmt$=\text{'}467\mathrm{.}85\text{'}.(-1)$

The system was unable to execute your query so it could not evaluate if it produces a column named CustomerID. $(-1)$

$-$ The system was unable to execute your query so it could not evaluate if it produces a column named SaleID. $(-1)$

The system was unable to execute your query so it could not evaluate if it produces a column named SumSaleAmt. $(-1)$