SELECT

gla.account$\_$description

$,$ COUNT$(*)$

$,$ SUM$($ili$.$line$\_$item$\_$amount$)$

$,$ invoice$\_$date

FROM general$\_$ledger$\_$accounts gla

INNER JOIN invoice$\_$line$\_$items ili

ON ili.account$\_$number $=$ gla.account$\_$number

GROUP BY gla.account$\_$description

HAVING COUNT$(*)>1$

ORDER BY SUM$($ili$.$line$\_$item$\_$amount$)$ DESC

;

Modify the solution to exercise $4$ so it returns only invoices dated in the second quarter of $2018($April $1,2018$ to June $30,2018).$ This should still return $10$ rows but with some different line item counts for each vendor. Hint: Join to the Invoices table to code a search condition based on invoice$\_$date.