DPQL_PERCENT allows us to check the percentage of a group that meets a specified condition.
We'd like to check the Percentage of tickets that have been submitted to our helpdesk that have been resolved.
To do this we simply run the query below
SELECT DPQL_PERCENT(tickets.status IN ('resolved', 'archived')) AS 'Percentage of tickets resolved' FROM tickets
The query finds the total number of statuses in 'tickets' and then calculates the percentage of these that match the condition specified 'tickets.status IN ('resolved', 'archived')'
In this instance 29.11 %.