MIS582 Week 1 lab Complete Solution Scored

Question: #825

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.