MIS 582 Database Concepts Week 1 iLab Answers – Homeworkmade

DOWNLOAD: MIS 582 Database Concepts Week 1 iLab Answers – Homeworkmade

MIS 582 Week 1 iLab

1. Write a SQL statement to display Students’ First and Last Name.

2. Write a SQL statement to display the Major of students 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 88888.

4. 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.

5. 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.

6. Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.

7. 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 the SQL command BETWEEN.

8. Write a SQL statement to display the First and Last Name of students who have a 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 names.

10. Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus.  Group by Status and display the results in descending order of SumOfStatus.