Ok Guys... Been a long time and thought what geeks do I know....


I have a damn SQL statement I need to write and I do not do SQL AT ALL....

Working with MS SQL 2008 R2

Need to do following.. ASAP


1. Calculate the number of exempt and non-exempt
employees there are, by job title. The results should be
sorted in descending order.

2. Determine if you have any employees whose salary is
below the minimum salary for their job classification. If
so, who are they?

3. Calculate the average, minimum and maximum salary
for exempt employees. Using the UNION command also
display the same information for the non-exempt
employees.

4. Calculate the difference between the maximum and
minimum salaries for the non-exempt employees.
Create a query that shows all employees whose name
has the second letter of either an ‘a’,’e’,’i’,’r’ or ‘u’.


Again... I do not work with SQL this is for a damn course I gotta finish.


By All means email me at beerguy.cdg@gmail.com

Later all Booze