It's been a long day and I'm not getting my head around this at the moment.
I have a table with batch numbers and statuses. What I would like to do with SQL is get a result with one row for each batch with the lowest status. See the image below for what I'm getting at.
Does anyone have a suggestion on how I would set this SQL statement up?