[Koha] SQL for Report generation - Help needed

Can anyone help me to write the sql code for retrieving Most checked out books of a particular range of call numbers and the patron who took those books. Regards manoj -- manoj