swipejobs interview question

Implement a SQL query to select some data with condition