Added query 9 for pharmacist user.