title: SQL Finding Hourly Wage From Annual Salary And Hourly Wage Values
body: <p>Normally finding hourly wage is simple SQL statement. But, as seen with the data below, the SalaryWage column has values that are stored as yearly wage and hourly wage. I need to sort it by who has the highest hourly wage. Somehow you need to take the SalaryWage column that has the annual wages listed and convert just those values to hourly wage. Then sort via the hourly wage.</p>
  
  <p>This is what I have so far so you can see the names of my tables and such.</p>
  
  <pre><code>select EMPLOYEEID, LASTNAME || ', ' || FIRSTNAME As Employee_Name, HIREDATE, SALARYWAGE
  from EMPLOYEE;
  </code></pre>
  
  <p>Download the Excel File below
  <a href="http://www.filedropper.com/book1_6" rel="nofollow">http://www.filedropper.com/book1_6</a></p>
  
  <pre><code>EmployeeID    Employee_Name    HIREDATE    SALARYWAGE
  100001        Manaugh, Jim     15-Mar-09   75500
  100101        Rosner, Joanne   4-Apr-09    16.3
  100103        Bush, Rita       30-Jan-09   85800
  </code></pre>