These analytic queries (Table 3) involve computed columns using the results of base queries for revenues/costs. Profit involves sum of revenues from invoices minus sum of total costs from subjobs. Total costs are the sum of labor, material, machine, and overhead. The base query for cost summary calculates the sum of each cost component so total costs is the sum of the component costs. Profit margin is sum of profit divided by sum of revenues. Profit margin is a widely used business measure for comparing business performance across different kinds of products. Table 3: Analytic Query Requirements for Location Revenue Trends Analytic Query Analytic Functions Other Columns Notes AQ3: Rank locations by Rank in descending order of Location name, contract Use CTEs for BQ2 and descending sum of annual sum of profit; Restart year, sum of profit BQ3 in the FROM annual profit ranks for each year clause; Sum of profit calculated as sum of invoice amount minus sum of total costs (labor, material, machine, and overhead AQ4: Rank locations by Rank in descending order of Location name, contract Use CTEs for BQ2 and descending annual profit annual profit margin; Restart year, profit margin BQ3 in the FROM margin ramke for each year clause; Profit margin calculated as annual gum of profit divided by annual sum of invoice See AQ3 for calculation of gum of profit AQ5: Percent rank of job Percent rank of profit margin Job id, location name, Use CTEs for BQ2 and profit margins for for jobs; Use all jobs so no contract year, contract BQ3 in the FROM locations restarting of percent ranks month, profit margin clange See AQ4 for calculation of profit margin AQ6: Top performers of Percent rank of profit margin Job id, location name, Refinement of AQ5 to percent rank of job profit for jobs; Use all jobs so no contract year, contract show only top 5% of job margins for locations restarting of percent ranks month, profit margin profit margins; Use AQ5 in the FROM clause or make a CTE for AQ5 and use the new CTE in the FROM clause