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

A bar chart shows the distribution of date_address_from and the sum of monthly_rental , and group by attribute other_details and bin date_address_from by weekday.
SELECT date_address_from, SUM(monthly_rental) FROM Student_Addresses GROUP BY other_details ORDER BY monthly_rental DESC
SELECT "date_address_from", SUM("monthly_rental") FROM "Student_Addresses" GROUP BY "other_details" ORDER BY "monthly_rental" DESC NULLS LAST