If this request is of any use to anyone else, here is an SQL command that I use to display the open tickets assigned to a specific team via SQL.
For information, we use the IDs 1 and 6 for the ticket status "open"...
Displays all open tickets assigned to the specified team:
SELECT ost_ticket.ticket_id, ost_ticket.number, ost_ticket.status_id, ost_team.name, ost_staff.username, ost_ticket__cdata.subject FROM ost_ticket JOIN ost_team ON ost_team.team_id = ost_ticket.team_id JOIN ost_staff ON ost_staff.staff_id = ost_ticket.staff_id JOIN ost_ticket__cdata ON ost_ticket__cdata.ticket_id = ost_ticket.ticket_id WHERE ost_ticket.status_id IN (1, 6) AND ost_ticket.team_id = 9;
Output:

Only shows open tickets that are assigned to the specified team and marked as overdue:
SELECT ost_ticket.ticket_id, ost_ticket.number, ost_ticket.status_id, ost_team.name, ost_staff.username, ost_ticket.isoverdue, ost_ticket.est_duedate, ost_ticket__cdata.subject FROM ost_ticket JOIN ost_team ON ost_team.team_id = ost_ticket.team_id JOIN ost_staff ON ost_staff.staff_id = ost_ticket.staff_id LEFT JOIN ost_ticket__cdata ON ost_ticket.ticket_id = ost_ticket__cdata.ticket_id WHERE ost_ticket.status_id IN (1, 6) AND ost_ticket.isoverdue = 1 AND ost_ticket.team_id = 9;
Output:

Greetings,
Davokin