Checkouts in the last month based upon patron city's code.sql

SELECT psc.description, COUNT(*) [Quantity]

FROM PolarisTransactions.Polaris.TransactionHeaders th WITH (NOLOCK)

JOIN PolarisTransactions.Polaris.TransactionTypes tt WITH (NOLOCK)

        ON th.TransactionTypeID = tt.TransactionTypeID 

JOIN PolarisTransactions.Polaris.TransactionDetails td WITH (NOLOCK)

        ON th.TransactionID = td.TransactionID

        AND td.TransactionSubTypeID = 6

JOIN PolarisTransactions.Polaris.TransactionSubTypes sub WITH (NOLOCK)

        ON td.TransactionSubTypeID = sub.TransactionSubTypeID

JOIN Polaris.Polaris.PatronRegistration pr WITH (NOLOCK)

        ON td.numValue = pr.PatronID

JOIN Polaris.Polaris.PatronStatClassCodes psc WITH (NOLOCK)

        ON pr.StatisticalClassID = psc.StatisticalClassID

JOIN PolarisTransactions.Polaris.TransactionDetails tdMat WITH (NOLOCK)

        ON tdMat.TransactionID = th.TransactionID

        AND tdMat.TransactionSubTypeID = 4

JOIN PolarisTransactions.Polaris.TransactionSubTypes subMat WITH (NOLOCK)

        ON tdMat.TransactionSubTypeID = subMat.TransactionSubTypeID

JOIN Polaris.Polaris.MaterialTypes mt WITH (NOLOCK)

        on tdMat.numValue = mt.MaterialTypeID

WHERE th.TransactionTypeID IN (6001)

AND MONTH(TransactionDate) = MONTH(DateAdd(Month,-1,GETDATE()))

AND YEAR(TransactionDate) = YEAR(DATEADD(Month,-1,GETDATE()))

GROUP BY psc.Description

ORDER BY psc.Description