title: Query Calculations and Temporary Tables
body: <p>I have a question regarding structuring a query. I have 5 tables in which I need particular data from or data that needs to be manipulated from. I need to make calculations based upon the data in these tables, but first I need to display the columns with the data that I do not need to make any calculations on. What I have done so far is I have made a temporary table and queried all of the columns as needed into that table. My next task and thought process is to make another temporary table and do all of the calculations and fill them in, then join both temporary tables into one table. </p>
  
  <p>My problem: For all of these calculations, some require an average based calculation, count, sum, etc which in total will have at least 10 new columns. The issue I am having is structuring a query that will allow me to achieve these calculations from the table(s) and to achieve my desired results. Can anyone help aid in this complex query and structure of it?</p>