select snap_id,dbid, event,event_id, p1text, p1 file_no,sum(time_waited) time ,sum(p3) blocks
where event is not null
group by snap_id,dbid, event,event_id, p1text, p1
order by snap_id, event
The select list is underlined in yellow and the suggested correction is to change the group by clause to
event, snap_id, p1text, event_id, dbid
As well as being in a bizarre order, it is missing p1.
If I remove the file_no column alias, it seems to work.