Starting with the end in mind (hi covey) is actually not such a bad idea. First state what result you want the query to produce,and then start describing where

Starting with the end in mind (hi covey) is actually not such a bad idea. First state what result you want the query to produce,and then start describing where that data should come from. Updates aren't different from select statements: first you state what you want, update a table with some new column values, and then you state where this data should come from, and what data you want to update.