CREATE TABLE Course_Authors_and_Tutors (author_id INT, author_tutor_ATB VARCHAR, login_name VARCHAR, password VARCHAR, personal_name VARCHAR, middle_name VARCHAR, family_name VARCHAR, gender_mf VARCHAR, address_line_1 VARCHAR)
CREATE TABLE Subjects (subject_id INT, subject_name VARCHAR)
CREATE TABLE Courses (course_id INT, author_id INT, subject_id INT, course_name VARCHAR, course_description VARCHAR)
CREATE TABLE Student_Tests_Taken (registration_id INT, date_test_taken DATETIME, test_result VARCHAR)
CREATE TABLE Students (student_id INT, date_of_registration DATETIME, date_of_latest_logon DATETIME, login_name VARCHAR, password VARCHAR, personal_name VARCHAR, middle_name VARCHAR, family_name VARCHAR)
CREATE TABLE Student_Course_Enrolment (registration_id INT, student_id INT, course_id INT, date_of_enrolment DATETIME, date_of_completion DATETIME)

A bar chart for finding the number of the enrollment date for all the tests that have 'Pass' result, could you sort by the the number of date of enrolment in ascending?
SELECT date_of_enrolment, COUNT(date_of_enrolment) FROM Student_Course_Enrolment AS T1 JOIN Student_Tests_Taken AS T2 ON T1.registration_id = T2.registration_id WHERE T2.test_result = "Pass" ORDER BY COUNT(date_of_enrolment)
SELECT "date_of_enrolment", COUNT("date_of_enrolment") FROM "Student_Course_Enrolment" AS "T1" JOIN "Student_Tests_Taken" AS "T2" ON "Pass" = "T2"."test_result" AND "T1"."registration_id" = "T2"."registration_id" ORDER BY COUNT("date_of_enrolment") NULLS FIRST