Devam Ediyor

515731 [url removed, login to view] to Create Queries in Access usingS 2

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, sql less, second last name, p sql, urgent p, sql queries, sql access, queries, database queries, cst , course math, biology project, create zip code, create file table access, queries database, deadline sunday, statement position, sql statement help, status create, write sql queries, table queries, need access programmer, create table using, create code access

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

Proje NO: #2261663