What's wrong with this query?

There's nothing wrong with the queryIt should also select the column we put a condition on, type

There's nothing wrong with the query.