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

Give the number of each course name with at least five enrollments Return a bar chart, and could you rank in descending by the X-axis?
SELECT T1.CName, COUNT(T1.CName) FROM Course AS T1 JOIN Enrolled_in AS T2 ON T1.CID = T2.CID GROUP BY T1.CName, T2.CID HAVING COUNT(*) >= 5 ORDER BY T1.CName DESC
SELECT "T1"."CName", COUNT("T1"."CName") FROM "Course" "T1" JOIN "Enrolled_in" "T2" ON "T1"."CID" = "T2"."CID" GROUP BY "T1"."CName", "T2"."CID" HAVING COUNT(*) >= 5 ORDER BY "T1"."CName" DESC