Easy way to segment your data is to use filtered data extension. Here we can use user interface to set up conditions as we like. When you want to add this newly filtered data extension to the SQL activity you will find that data extension cannot be found in the file browser.
But it is there!
You can query it just like another DE from the SQL activity or Query studio. Just get the name and you are good to go.