Advertisement
digitalgraphiti

Untitled

Jan 3rd, 2020
339
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT
  2. statistics.borrowernumber AS BorrowerNumber,
  3. sum(items.replacementprice) AS AmountSavedUsingLibrary
  4. FROM
  5. statistics
  6. INNER JOIN items USING (itemnumber)
  7. WHERE
  8. date(statistics.datetime) BETWEEN <<Checked out BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
  9. AND statistics.type = 'issue'
  10. GROUP BY statistics.borrowernumber
  11. ORDER BY AmountSavedUsingLibrary DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement