SOLVE FOR SQL:

Given a table events with the following structure: create table events (sensor_id integer not null, event_type integer not null, value integer not null, time timestamp unique not null): write an SQL query that, for each sensor and event type (sensor_id, event_type), returns the most recent value (in terms of time). The table should be ordered by sensor_id (in ascending order), event_type (in ascending order). For example, given the following data: your query should return the following rowset: The names of the columns in the rowset don't matter, but their order does