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 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 Assessment_Notes (notes_id NUMBER, student_id NUMBER, teacher_id NUMBER, date_of_notes DATETIME, text_of_notes VARCHAR2, other_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)
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_Detention_Type (detention_type_code VARCHAR2, detention_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 Ref_Incident_Type (incident_type_code VARCHAR2, incident_type_description 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 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)

A line chart shows the trend of the sum of monthly_rental over date_address_to , and group by attribute other_details.
SELECT date_address_to, SUM(monthly_rental) FROM Student_Addresses GROUP BY other_details, date_address_to ORDER BY monthly_rental DESC
SELECT "date_address_to", SUM("monthly_rental") FROM "Student_Addresses" GROUP BY "other_details", "date_address_to" ORDER BY "monthly_rental" DESC