Why was this denied?
You asked:
"Using the Student table in the database provided, perform the following tasks:
Write a SQL statement to display First and Last Name.
Write a SQL statement to display the Major of the student with no duplications.
Write a SQL statement to display the First and Last name of students who live in the Zip code 88888.
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.
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.
Write a SQL statement to display the First and Last name of students who have the major of Biology or Math. Use IN.
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.
Write a SQL statement to display the First and Last name of students who have the Last Name that starts with an S.
Write a SQL statement to display the First and Last name of students having an 'a' in the second position in their First Name.
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. Using the Student table in the database provided in the Doc Share (Lab 5 SQL.accdb), perform the following tasks (each query is worth 10 points):
Write a SQL statement to display First and Last Name.
Write a SQL statement to display the Major of the student with no duplications.
Write a SQL statement to display the First and Last name of students who live in the Zip code 88888.
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.
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.
Write a SQL statement to display the First and Last name of students who have the major of Biology or Math. Use IN.
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.
Write a SQL statement to display the First and Last name of students who have the Last Name that starts with an S.
Write a SQL statement to display the First and Last name of students having an 'a' in the second position in their First Name.
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. "
- Sent to Computer Science Expert Tutor on 1/31/2011 at 9:44am