Database homework | Computer Science homework help

 

For the following relational model:

Don't use plagiarized sources. Get Your Custom Essay on
Database homework | Computer Science homework help
Just from $13/Page
Order Essay

Student(sid, fname, lname, gpa)
Course ( cid, code, name, credithours)
Enrolled (sid, cid,grade)

Write SQL queries for the following:

  1. Print all the students by the name order desc by the gpa.
  2. Print all the computer sciences courses, these courses with code start with ‘CS’
    sorted alphabetically.
  3. Print all the students with a gpa less than 3.0
  4. Print all the students with a gpa of a least 3.0
  5. Find all students that have enrolled in database course
  6. Find all students that have enrolled in database and network courses
  7. Find all the students that have (A or more) at least once

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper