Report for tickets closed within same queue (First Level Resolution)
You can use a sub-select statement:
SELECT HD_TICKET.ID, TITLE, CREATED, TIME_CLOSED
WHERE CREATED < date_sub(NOW(), INTERVAL 1 MONTH)
AND HD_QUEUE_ID = 2
AND (SELECT COUNT(ID) FROM HD_TICKET_CHANGE
WHERE DESCRIPTION like "%Changed ticket Queue%"
AND HD_TICKET_ID = HD_TICKET.ID
GROUP BY HD_TICKET_ID) is null
GROUP BY HD_TICKET.ID
That query will show the tickets opened in a specific queue in the past month that were not transferred to another queue.