Minor adjustments may be necessary as I have not yet tested whether the dates loaded are always correct, but it will never be very different from the list I get with the code below: SELECT p.id…
3 tables: Processo, Evento, Alerta The goal is to make a query that returns all processes by adding the columns of the most recent event type and date MAX(DataEvento) and the next warning (shorter…