MIS 582 Week 1 iLab Solution Database Concepts

Using the STUDENT table in the MISLab1 database in Omnymbus, perform the following tasks (each query is 5 points):

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 each Status and the number of occurrences of each status using the Count(*) function; display the result of the Count(*) function as CountStatus. Group by Status and display the results in descending order of CountStatus.
    

    MIS 582 Week 1 iLab Solution Database Concepts.

    Order 100% plagiarism free essay on  1 iLab Solution Database Concepts