MIS 582 Week 1 iLab Solution Database Concepts

 

Premium Theses

Order Now

Order Now

MIS 582 Week 1 iLab Solution Database Concepts.

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

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

Share this

What You Get

Authentic Thesis

Authentic Thesis

Order Paper Now

Order Paper Now
 
error: Content is protected !!