This video goes over the Select Statement and some crucial clauses (FROM and WHERE) to utilize with the select statement to refine queries. 

I pulled the example Data and Schema from this class: https://www.edx.org/course/databases-5-sql

As always, feel free to checkout our wesbite Here and contact us if you or your company needs any assistance.