title: How to multiply the results of two different queries
body: <p>I have three tables: Employee, BillingRates, and WorkHours.</p>
  
  <pre><code>Employees
  ------------------------------
  EmpID | name | titleID | level  
  
  BillingRates
  ----------------------
  titleID | level | rate
  
  WorkHours
  -------------------
  EmpID | HoursWorked
  </code></pre>
  
  <p>This query gives me the names and rate for each employee:  </p>
  
  <pre><code>select 
      firstname, lastname, rate
  from employees 
  left join billingrates
      on employees.TitleID = BillingRates.TitleID
      and employees.Level = BillingRates.Level
  </code></pre>
  
  <p>This gives me the EmpID and total hours worked by that employee:</p>
  
  <pre><code>select 
      employees.EmpID, sum(workhours.hoursworked) as TotalHours
  from employees 
  inner join workhours
      on employees.empid = WorkHours.EmpID
  where 
      WH_Month = 4
  group by 
      LastName, firstname, employees.EmpID  
  </code></pre>
  
  <p>I need to multiply the rate output by the total hours worked by that employee.<br>
  Would someone be able to assist with writing a query that generates that output?  </p>