CREATE TABLE Course (CID VARCHAR, CName VARCHAR, Credits INT, Instructor INT, Days VARCHAR, Hours VARCHAR, DNO INT)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Enrolled_in (StuID INT, CID VARCHAR, Grade VARCHAR)
CREATE TABLE Faculty (FacID INT, Lname VARCHAR, Fname VARCHAR, Rank VARCHAR, Sex VARCHAR, Phone INT, Room VARCHAR, Building VARCHAR)
CREATE TABLE Gradeconversion (lettergrade VARCHAR, gradepoint FLOAT)
CREATE TABLE Minor_in (StuID INT, DNO INT)
CREATE TABLE Department (DNO INT, Division VARCHAR, DName VARCHAR, Room VARCHAR, Building VARCHAR, DPhone INT)
CREATE TABLE Member_of (FacID INT, DNO INT, Appt_Type VARCHAR)

A scatter chart shows the correlation between CID and Instructor .
SELECT CID, Instructor FROM Course ORDER BY Credits
SELECT "CID", "Instructor" FROM "Course" ORDER BY "Credits" NULLS FIRST