Bad design. Makes it tough to create a good query.
Your only real choice is 5 separate queries, though you could use a UNION to make it *look* like one query.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.