Zinnia Interview Question

How would I query data in SQL without using case statements.