CREATE TABLE Ref_Calendar (Calendar_Date DATETIME, Day_Number NUMBER)
CREATE TABLE All_Documents (Document_ID NUMBER, Date_Stored DATETIME, Document_Type_Code CHAR, Document_Name CHAR, Document_Description CHAR, Other_Details VARCHAR2)
CREATE TABLE Documents_to_be_Destroyed (Document_ID NUMBER, Destruction_Authorised_by_Employee_ID NUMBER, Destroyed_by_Employee_ID NUMBER, Planned_Destruction_Date DATETIME, Actual_Destruction_Date DATETIME, Other_Details VARCHAR2)
CREATE TABLE Employees (Employee_ID NUMBER, Role_Code CHAR, Employee_Name VARCHAR2, Gender_MFU CHAR, Date_of_Birth DATETIME, Other_Details VARCHAR2)
CREATE TABLE Ref_Document_Types (Document_Type_Code CHAR, Document_Type_Name VARCHAR2, Document_Type_Description VARCHAR2)
CREATE TABLE Ref_Locations (Location_Code CHAR, Location_Name VARCHAR2, Location_Description VARCHAR2)
CREATE TABLE Document_Locations (Document_ID NUMBER, Location_Code CHAR, Date_in_Location_From DATETIME, Date_in_Locaton_To DATETIME)
CREATE TABLE Roles (Role_Code CHAR, Role_Name VARCHAR2, Role_Description VARCHAR2)

Show the number of documents in different starting date. Bin starting date by weekday and group by location code with a stacked bar chart.
SELECT Date_in_Location_From, COUNT(Date_in_Location_From) FROM Document_Locations GROUP BY Location_Code
SELECT "Date_in_Location_From", COUNT("Date_in_Location_From") FROM "Document_Locations" GROUP BY "Location_Code"