asked on

Please help me with my Microsoft Access SQL statements..............ASAP if possible..TY in advance

USING MICROSOFT ACCESS SQL View

Sorry im new to this SQL stuff..

Here are my Access DB tables with no table relationships yet, please help with relationships too if possible. Thank you! :)

Here are my Access DB tables :

**Employee**
•      Social_security_number
•      Last_name
•      First_name
•      Address
•      City
•      State
•      Zip_code
•      Telephone_area_code
•      Telephone_number
•      Email_address
•      Job_title_code
•      Hire_date
•      Salary

**Job_title**
•      Job_title_code
•      Job_title
•      Exempt_non_exempt_status
•      Minimum_salary
•      Maximum_salary

----------------------------------------------------------------------------------------------------

**Using my Access DB tables (Employee and job_title) please write SQL statements to:
Calculate the average salary for all employees.
Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
Calculate the maximum salary for all employees.
Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
Calculate the minimum salary for all employees.
Print out the SQL statements and the results.

peter57r

Hi ZACKYJONESKI,

The conditions of EE are that homework questions are not allowed.
You might get some help with a specific SQL statement if you can't get it to work correctly but that's about it.

Pete

iseafan

Try these links:
http://www.w3schools.com/

http://www.sqlzoo.net/
http://forums.devshed.com/archive/f-95
http://www.cryer.co.uk/brian/sql/sql_crib_sheet.htm
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain.htm
http://www.totalsoft.com.br/sqlhelp.htm
http://www.mckoi.com/database/SQLSyntax.html
http://www.dbmaker.com/reference/manuals/sql/toclist.htm

MitchellVII

Pete, lol, have they no shame? Getting us to do their homework...:)

lol

ZACKYJONESKI

ASKER

HEY MitchellVII! No need for the rude comments... You dont know what you're talking about. You know what, i just wanted to know how its done at first, just like the examples on the sams book, that does not necessary mean I will copy it and turn it in. There so many way I can query a db. I followed all the links ISEAFAN... Thank you Sir/Mam it helped me a lot! :)

but for you MitchellVII -------- YOU'RE USELESS, YOU WANNA BE SQL/ACCESS EXPERT.

MITCHELLVII! YOU DONT KNOW WHAT YOU'RE TALKING ABOUT. YOU SHOULD READ UP SOME MORE BOOKS, GO BACK TO SCHOOL, YOU USELESS FOOL! GET UP AND GET A REAL JOB YOU NERD!!!!!!!!

ZACKYJONESKI

ASKER

any way i can round up this query AVG to the nearsest decimal?
This is my current OUTPUT 43.6666666666667

Thank you in advance!

SELECT AVG(age) AS Average_Actors_Age
FROM actors

ASKER CERTIFIED SOLUTION

iseafan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial