to return IDs that have at least one "in" status you may find this query suitable-

SELECT DISTINCT id
FROM status
WHERE status = 'in';