CREATE TABLE Student_Addresses (student_id NUMBER, address_id NUMBER, date_address_from DATETIME, date_address_to DATETIME, monthly_rental NUMBER, other_details VARCHAR2)
CREATE TABLE Assessment_Notes (notes_id NUMBER, student_id NUMBER, teacher_id NUMBER, date_of_notes DATETIME, text_of_notes VARCHAR2, other_details VARCHAR2)
CREATE TABLE Ref_Detention_Type (detention_type_code VARCHAR2, detention_type_description VARCHAR2)
CREATE TABLE Detention (detention_id NUMBER, detention_type_code VARCHAR2, teacher_id NUMBER, datetime_detention_start DATETIME, datetime_detention_end DATETIME, detention_summary VARCHAR2, other_details VARCHAR2)
CREATE TABLE Behavior_Incident (incident_id NUMBER, incident_type_code VARCHAR2, student_id NUMBER, date_incident_start DATETIME, date_incident_end DATETIME, incident_summary VARCHAR2, recommendations VARCHAR2, other_details VARCHAR2)
CREATE TABLE Ref_Incident_Type (incident_type_code VARCHAR2, incident_type_description VARCHAR2)
CREATE TABLE Teachers (teacher_id NUMBER, address_id NUMBER, first_name VARCHAR2, middle_name VARCHAR2, last_name VARCHAR2, gender VARCHAR2, cell_mobile_number VARCHAR2, email_address VARCHAR2, other_details VARCHAR2)
CREATE TABLE Addresses (address_id NUMBER, line_1 VARCHAR2, line_2 VARCHAR2, line_3 VARCHAR2, city VARCHAR2, zip_postcode VARCHAR2, state_province_county VARCHAR2, country VARCHAR2, other_address_details VARCHAR2)
CREATE TABLE Students (student_id NUMBER, address_id NUMBER, first_name VARCHAR2, middle_name VARCHAR2, last_name VARCHAR2, cell_mobile_number VARCHAR2, email_address VARCHAR2, date_first_rental DATETIME, date_left_university DATETIME, other_student_details VARCHAR2)
CREATE TABLE Students_in_Detention (student_id NUMBER, detention_id NUMBER, incident_id NUMBER)
CREATE TABLE Ref_Address_Types (address_type_code VARCHAR2, address_type_description VARCHAR2)

Find the dates of assessment notes for students with first name 'Fanny', and count them by a bar chart, and I want to order by the how many date of notes from high to low.
SELECT date_of_notes, COUNT(date_of_notes) FROM Assessment_Notes AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.first_name = "Fanny" ORDER BY COUNT(date_of_notes) DESC
SELECT "date_of_notes", COUNT("date_of_notes") FROM "Assessment_Notes" "T1" JOIN "Students" "T2" ON "Fanny" = "T2"."first_name" AND "T1"."student_id" = "T2"."student_id" ORDER BY COUNT("date_of_notes") DESC