Support for Nested SQL queries

I was trying to get this running with nested select statements, so I was wondering if you have a work-around for that. My SQL statement was something like, 
``SELECT sub.* FROM (SELECT * FROM tutorial.sf_crime_incidents_2014_01 WHERE day_of_week = 'Friday') sub WHERE sub.resolution = 'NONE``
Can this be made to work? 
Thanks for the time. Cheers!