SQL SQL Querying Off A Subquery Using A Common Table Expression Updating A Table By Joining To Another Table Retrieving Vertically Stored Data Horizontally