515641 URGENT.Programer needed to create queries inAccess usingSQL
N/A
Sürüyor
İlan edilme: 12 yıldan fazla önce
N/A
Teslimde ödenir
Hello! I need a programmer to help me with an assignment I have. I'm under a tight deadline. VERY IMPORTANT!! All work needs to be complete and submitted to me by Sunday August 7, 2011 at 8:00 p.m. CST (GMT-06:00). Please let me know as soon as possible with your bid and timeline. Thank you so much!!
The Project is as follows:
The objective of this week's course project is to create queries in Access using SQL.
Using the Student table (document is in attached file), perform the following tasks:
1. Write a SQL statement to display First and Last Name.
2. Write a SQL statement to display the Major of the student with no duplications.
3. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888.
4. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888 and have the major of Biology.
5. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888 or 88808. Do not use IN.
6. Write a SQL statement to display the First and Last name of students who have the major of Biology or Math. Use IN.
7. Write a SQL statement to display the First and Last name of students who have the Status greater than 1 and less than 10. Use BETWEEN.
8. Write a SQL statement to display the First and Last name of students who have the Last Name that starts with an S.
9. Write a SQL statement to display the First and Last name of students having an 'a' in the second position in their First Name.
10. Write a SQL expression to display the Status and a sum of SumOfStatus, grouped by Status. Name the count "SumOfStatus" and display the results in descending order of SumOfStatus.
Name the database [login to view URL]
Thank you for your time and Consideration. I look forward to hearing from you.