Create SQL SELECT Queries:Using the data in the Student table in the database
Create SQL SELECT Queries:Using the data in the Student table in the database, create a SQL script
file named LastName_Lab1_Query.sql, containing queries to execute each of the tasks below. To reference, learn and apply MySQL’s own dialect of the SQL language to this iLab, browse through the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.Save each query with a screen shot of the output in a MS Word document named Lastname_Lab1_Output.
| Write a SQL statement to display Student’s First and Last Name. |
| Write a SQL statement to display the Major of students with no duplications. Do not display student names. |
| Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622 |
| 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. |
| 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. |
| Write a SQL statement to display the First and Last Name of students who have the major of Business or Math. Use IN. |
| 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 the SQL command BETWEEN. |
| Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S. |
| Write a SQL statement to display the First and Last Name of students having an a in the second position of their first names. |
| 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 |
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
