Devam Ediyor

515641 [url removed, login to view] needed to create queries inAccess usingSQL

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 [url removed, login to view]

Thank you for your time and Consideration. I look forward to hearing from you.

Beceriler: Her şey Kabul, Microsoft Access, PHP, SQL

Daha fazlasını görün: objective statement, math programmer, need programer code, sql less, second last name, p sql, urgent p, sql work needed, sql queries, queries, programer, programer needed, php programer, database queries, cst , course math, c programer, biology project, create zip code, create file table access, queries database, deadline sunday, statement position, sql statement help, status create

İşveren Hakkında:
( 3 değerlendirme )

Proje NO: #2261573