[Koha] How to get sql report on patron additional attributes.

[MASTeR Library]

Dear Team,
how to get the sql report on Patron additional attributes for example
Department, Student Roll number, blood group and etc?

Sample SQL Code.
SELECT ROW_NUMBER() OVER (ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC)
 AS 'S.No',
borrowers.cardnumber AS "Lib Membership
No",borrowers.borrowernumber,borrowers.surname AS "
Name",borrowers.title,borrowers.sex,borrowers.dateofbirth AS " Date of
Birth",borrowers.contactname AS "Guardian Name", borrowers.relationship,
borrowers.phone,borrowers.email,borrowers.address,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.userid
FROM borrowers WHERE branchcode=<<Enter patrons library|branches>> AND
categorycode LIKE <<Select User category|categorycode>>
-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.