Patients by Insurance Carrier and Group Number

Is there a patient report that lists all patients by insurance group number?

SELECT 
  a.payorname,a.insgroup,b.lastname,b.firstname,b.id
FROM 
  sos.rv_policies a JOIN sos.patients b ON a.ptnum = b.ptnum
WHERE 
  today() BETWEEN COALESCE(a.active,'1900-01-01') AND COALESCE(a.inactive,'2100-12-31')
ORDER BY 
  payorname, insgroup, b.lastname, b.firstname, b.id