SQL codeList the State, City, Month, Total Transaction amount $($Tran$\_$Amt column$)$ during each month in $2015$ for stores located in two cities in Texas, namely, Houston and Dallas. Summary rows with total transaction

amounts for these cities and overall total for these two cities should be displayed. $($Note $-$ Please refer to the Store and Transact tables; FORMAT$($column name$/$expression$,\text{'}$C$\text{'})$ for currency format; MONTH$($Tran$\_$Date$)$ to get month of the transaction date; YEAR$($Tran$\_$Date$)$ to get year of the transaction date; there are two types of transactions in the Tran$\_$Type column: purchase and returns, please consider only the purchase transactions.$)$