Q&A for those involved in the field of teaching Computer Science
-- all entries in the post table -- for users in seattle select * from posts inner join users on posts.owneruserid = users.id and users.location like '%seattle%';