CREATE TABLE People (person_id NUMBER, first_name VARCHAR2, middle_name VARCHAR2, last_name VARCHAR2, cell_mobile_number VARCHAR2, email_address VARCHAR2, login_name VARCHAR2, password VARCHAR2)
CREATE TABLE Student_Course_Registrations (student_id NUMBER, course_id NUMBER, registration_date DATETIME)
CREATE TABLE Students (student_id NUMBER, student_details VARCHAR2)
CREATE TABLE Courses (course_id VARCHAR2, course_name VARCHAR2, course_description VARCHAR2, other_details VARCHAR2)
CREATE TABLE Candidate_Assessments (candidate_id NUMBER, qualification CHAR, assessment_date DATETIME, asessment_outcome_code CHAR)
CREATE TABLE People_Addresses (person_address_id NUMBER, person_id NUMBER, address_id NUMBER, date_from DATETIME, date_to DATETIME)
CREATE TABLE Candidates (candidate_id NUMBER, candidate_details VARCHAR2)
CREATE TABLE Student_Course_Attendance (student_id NUMBER, course_id NUMBER, date_of_attendance DATETIME)
CREATE TABLE Addresses (address_id NUMBER, line_1 VARCHAR2, line_2 VARCHAR2, city VARCHAR2, zip_postcode CHAR, state_province_county VARCHAR2, country VARCHAR2)

For all course_name from courses table, group by the course name and count them with a bar chart, and list in ascending by the x axis please.
SELECT course_name, COUNT(course_name) FROM Courses GROUP BY course_name ORDER BY course_name
SELECT "course_name", COUNT("course_name") FROM "Courses" GROUP BY "course_name" ORDER BY "course_name"