SQLite Forum

Can you see what I do wrong?
Login
The standard way would be to select what you want.  An example that should work in anything that understands generic SQL might be:

```
select (
        select name
          from log
         where dt == o.dt
           and time_in == o.time_in
           and max_out == o.max_out
       ) as name,
       dt,
       time_in
  from (
          select dt,
                 time_in,
                 max(time_out) as max_out
            from log
           where dt > '2021-03-13'
        group by dt, time_in
       ) as o
;
```