• Home
  • Blog
  • NLC A SQL Query to Get All Columns and Rows from The Students Table

NLC A SQL Query to Get All Columns and Rows from The Students Table

Daniel Kevins

0 comments

  1. Write a SQL query that would retrieve all columns and all rows from a table called Students.
  2. Write a SQL query that would retrieve the following columns from a table called Courses: CourseNumber, CourseName, Instructor, Room.
  3. Write a SQL query that would display the LastName, FirstName, Email and Major columns from the Students table where the Major column contains “Computer Science”;
  4. Write a SQL query that would return the LastName, FirstName, Major and GPA columns from the Students table sorted by GPA highest to lowest.
  5. Write a SQL query that will select the CourseNumber, CourseName, Department and Instructor columns from the Courses Table sorted by Department and then Instructor within department
  6. Write a SQL query that will retrieve the CourseNumber, CourseName, Room and Instructor for all Courses with Department = “Computer Science” sorted by CourseNumber and then Instructor.
Author Image

About the Author

Daniel Kevins

Follow me

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}