PatronMapper.xml

	<select id="getRemainingBorrowsForMonth" resultType="java.lang.Integer">
		select
			(
				select circsPerPatronMonth
				from Account
				where libraryId = (select libraryId from Patron where id=#{value})
			)
 			-
 			(
				select count(*)
				from Circ
				where patronId=#{value}
				date_trunc('month', borrowed) = date_trunc('month',now())
				and date_trunc('year', borrowed) = date_trunc('year',now())
 			)
	</select>