Logo
Question DetailsNormal
$ 15.00
MIS582 Week 1 lab | Complete Solution | Scored 100%
Question posted by
request

1. Write a SQL statement to display Student’s First and Last Name.
2. Write a SQL statement to display the Major of the STUDENT with no duplications. Do not display student names.
3. Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622.
4. Write a SQL statement to display the First and Last Name of students who live in the Zip code 97912 and have the major of CS.
5. Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622 or 37311. Do not use IN.
6. Write a SQL statement to display the First and Last Name of students who have the major of Business or Math. Use IN.
7. Write a SQL statement to display the First and Last Name of students who have the Class 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 the number of occurrences of each status; display the number of occurrences of each status as CountStatus. Group by Status and display the results in descending order of CountStatus.

Available Solution
$ 15.00
MIS582 Week 1 lab | Complete Solution | Scored 100%
  • This Solution has been Purchased 5 time
  • Submitted On 01 Feb, 2015 08:00:25
Solution posted by
solution
SELECT Status, COUNT(StudentID)...
Buy now to view full solution.
closebutton

$ 629.35