CREATE TABLE ref_incident_type (incident_type_code CLOB, incident_type_description CLOB)
CREATE TABLE student_addresses (student_id NUMBER, address_id NUMBER, date_address_from TIME, date_address_to TIME, monthly_rental NUMBER, other_details CLOB)
CREATE TABLE behavior_incident (incident_id NUMBER, incident_type_code CLOB, student_id NUMBER, date_incident_start TIME, date_incident_end TIME, incident_summary CLOB, recommendations CLOB, other_details CLOB)
CREATE TABLE students (student_id NUMBER, address_id NUMBER, first_name CLOB, middle_name CLOB, last_name CLOB, cell_mobile_number CLOB, email_address CLOB, date_first_rental TIME, date_left_university TIME, other_student_details CLOB)
CREATE TABLE students_in_detention (student_id NUMBER, detention_id NUMBER, incident_id NUMBER)
CREATE TABLE ref_address_types (address_type_code CLOB, address_type_description CLOB)
CREATE TABLE teachers (teacher_id NUMBER, address_id NUMBER, first_name CLOB, middle_name CLOB, last_name CLOB, gender CLOB, cell_mobile_number CLOB, email_address CLOB, other_details CLOB)
CREATE TABLE assessment_notes (notes_id NUMBER, student_id NUMBER, teacher_id NUMBER, date_of_notes TIME, text_of_notes CLOB, other_details CLOB)
CREATE TABLE addresses (address_id NUMBER, line_1 CLOB, line_2 CLOB, line_3 CLOB, city CLOB, zip_postcode CLOB, state_province_county CLOB, country CLOB, other_address_details CLOB)
CREATE TABLE detention (detention_id NUMBER, detention_type_code CLOB, teacher_id NUMBER, datetime_detention_start TIME, datetime_detention_end TIME, detention_summary CLOB, other_details CLOB)
CREATE TABLE ref_detention_type (detention_type_code CLOB, detention_type_description CLOB)

Find the id and first name of the student that has the most number of assessment notes?
SELECT T1.student_id, T2.first_name FROM assessment_notes AS T1 JOIN students AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."student_id", "T2"."first_name" FROM "assessment_notes" "T1" JOIN "students" "T2" ON "T1"."student_id" = "T2"."student_id" GROUP BY "T1"."student_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY