question

dawoodahmed avatar image
dawoodahmed asked

Display a list of all students with all attributes in the students table.

  1. Display a list of all students with all attributes in the students table.
  2. Display a list of all students with only the first name, last name, class standing and gpa attributes. Sort your results by student last name and then first name.
  3. Display a list of students with all attributes. Sort your results by major ID, GPA, then last name and first name.
  4. Display a list of all CSIS classes in the course catalog. Display only the department abbreviation, course number and course name. Sort your results by the course number in descending order.
  5. Use a compound condition to display a list of students who are seniors and whose GPA is greater than or equal to 3.0. Sort your results by GPA descending, then last name and first name.
  6. Use BETWEEN to display a list of all courses from the catalog whose course number is between 1 and 2000. Sort your results by the course abbreviation and course number.
  7. Use LIKE to display a list of all majors that contain the letters 'ology' in their name.
  8. Use IN to display a list of all courses from the course catalog that are from the departments COMM, FILM and SOC. Sort your results by the course abbreviation and course number.
mysql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jeff Moden avatar image
Jeff Moden answered

Dude... do your own damned homework.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.