CREATE TABLE Ref_Document_Types (
    Document_Type_Code TEXT PRIMARY KEY,
    Document_Type_Name TEXT,
    Document_Type_Description TEXT
);
CREATE TABLE Ref_Calendar (
    Calendar_Date TIME PRIMARY KEY,
    Day_Number NUMBER
);
CREATE TABLE Ref_Locations (
    Location_Code TEXT PRIMARY KEY,
    Location_Name TEXT,
    Location_Description TEXT
);
CREATE TABLE Roles (
    Role_Code TEXT PRIMARY KEY,
    Role_Name TEXT,
    Role_Description TEXT
);
CREATE TABLE All_Documents (
    Document_ID NUMBER PRIMARY KEY,
    Date_Stored TIME,
    Document_Type_Code TEXT,
    Document_Name TEXT,
    Document_Description TEXT,
    Other_Details TEXT,
    FOREIGN KEY ("Date_Stored") REFERENCES Ref_Calendar("Calendar_Date"),
    FOREIGN KEY ("Document_Type_Code") REFERENCES Ref_Document_Types("Document_Type_Code")
);
CREATE TABLE Employees (
    Employee_ID NUMBER PRIMARY KEY,
    Role_Code TEXT,
    Employee_Name TEXT,
    Gender_MFU TEXT,
    Date_of_Birth TIME,
    Other_Details TEXT,
    FOREIGN KEY ("Role_Code") REFERENCES Roles("Role_Code")
);
CREATE TABLE Document_Locations (
    Document_ID NUMBER PRIMARY KEY,
    Location_Code TEXT,
    Date_in_Location_From TIME,
    Date_in_Locaton_To TIME,
    FOREIGN KEY ("Document_ID") REFERENCES All_Documents("Document_ID"),
    FOREIGN KEY ("Date_in_Locaton_To") REFERENCES Ref_Calendar("Calendar_Date"),
    FOREIGN KEY ("Date_in_Location_From") REFERENCES Ref_Calendar("Calendar_Date"),
    FOREIGN KEY ("Location_Code") REFERENCES Ref_Locations("Location_Code")
);
CREATE TABLE Documents_to_be_Destroyed (
    Document_ID NUMBER PRIMARY KEY,
    Destruction_Authorised_by_Employee_ID NUMBER,
    Destroyed_by_Employee_ID NUMBER,
    Planned_Destruction_Date TIME,
    Actual_Destruction_Date TIME,
    Other_Details TEXT,
    FOREIGN KEY ("Document_ID") REFERENCES All_Documents("Document_ID"),
    FOREIGN KEY ("Actual_Destruction_Date") REFERENCES Ref_Calendar("Calendar_Date"),
    FOREIGN KEY ("Planned_Destruction_Date") REFERENCES Ref_Calendar("Calendar_Date"),
    FOREIGN KEY ("Destruction_Authorised_by_Employee_ID") REFERENCES Employees("Employee_ID"),
    FOREIGN KEY ("Destroyed_by_Employee_ID") REFERENCES Employees("Employee_ID")
);

Question: How many calendar items do we have?
SQL: SELECT count(*) FROM Ref_calendar

Question: Count the number of all the calendar items.
SQL: SELECT count(*) FROM Ref_calendar

Question: Show all calendar dates and day Numbers.
SQL: SELECT calendar_date ,  day_Number FROM Ref_calendar

Question: What are all the calendar dates and day Numbers?
SQL: SELECT calendar_date ,  day_Number FROM Ref_calendar

Question: Show the number of document types.
SQL: SELECT count(*) FROM Ref_document_types

Question: How many document types are there?
SQL: SELECT count(*) FROM Ref_document_types

Question: List all document type codes and document type names.
SQL: SELECT document_type_code ,  document_type_name FROM Ref_document_types

Question: What are all the document type codes and document type names?
SQL: SELECT document_type_code ,  document_type_name FROM Ref_document_types

Question: What is the name and description for document type code RV?
SQL: SELECT document_type_name ,  document_type_description FROM Ref_document_types WHERE document_type_code  =  "RV"

Question: Give me the name and description of the document type code RV.
SQL: SELECT document_type_name ,  document_type_description FROM Ref_document_types WHERE document_type_code  =  "RV"

Question: What is the document type code for document type "Paper"?
SQL: SELECT document_type_code FROM Ref_document_types WHERE document_type_name  =  "Paper"

Question: Find the code of the document type "Paper".
SQL: SELECT document_type_code FROM Ref_document_types WHERE document_type_name  =  "Paper"

Question: Show the number of documents with document type code CV or BK.
SQL: SELECT count(*) FROM All_documents WHERE document_type_code  =  "CV" OR document_type_code  =  "BK"

Question: How many documents have document type code CV or BK?
SQL: SELECT count(*) FROM All_documents WHERE document_type_code  =  "CV" OR document_type_code  =  "BK"

Question: What is the date when the document "Marry CV" was stored?
SQL: SELECT date_stored FROM All_documents WHERE Document_name  =  "Marry CV"

Question: When was the document named "Marry CV" stored? Give me the date.
SQL: SELECT date_stored FROM All_documents WHERE Document_name  =  "Marry CV"

Question: What is the day Number and date of all the documents?
SQL: SELECT T2.day_Number ,  T1.Date_Stored FROM All_documents AS T1 JOIN Ref_calendar AS T2 ON T1.date_stored  =  T2.calendar_date

Question: Return the day Number and stored date for all the documents.
SQL: SELECT T2.day_Number ,  T1.Date_Stored FROM All_documents AS T1 JOIN Ref_calendar AS T2 ON T1.date_stored  =  T2.calendar_date

Question: What is the document type name for the document with name "How to read a book"?
SQL: SELECT T2.document_type_name FROM All_documents AS T1 JOIN Ref_document_types AS T2 ON T1.document_type_code  =  T2.document_type_code WHERE T1.document_name  =  "How to read a book"

Question: Find the document type name of the document named "How to read a book".
SQL: SELECT T2.document_type_name FROM All_documents AS T1 JOIN Ref_document_types AS T2 ON T1.document_type_code  =  T2.document_type_code WHERE T1.document_name  =  "How to read a book"

Question: Show the number of locations.
SQL: SELECT count(*) FROM Ref_locations

Question: How many locations are listed in the database?
SQL: SELECT count(*) FROM Ref_locations

Question: List all location codes and location names.
SQL: SELECT location_code ,  location_name FROM Ref_locations

Question: What are all the location codes and location names?
SQL: SELECT location_code ,  location_name FROM Ref_locations

Question: What are the name and description for location code x?
SQL: SELECT location_name ,  location_description FROM Ref_locations WHERE location_code  =  "x"

Question: Give me the name and description of the location with code x.
SQL: SELECT location_name ,  location_description FROM Ref_locations WHERE location_code  =  "x"

Question: What is the location code for the country "Canada"?
SQL: SELECT location_code FROM Ref_locations WHERE location_name  =  "Canada"

Question: Show the location code of the country "Canada".
SQL: SELECT location_code FROM Ref_locations WHERE location_name  =  "Canada"

Question: How many roles are there?
SQL: SELECT count(*) FROM ROLES

Question: Count the total number of roles listed.
SQL: SELECT count(*) FROM ROLES

Question: List all role codes, role names, and role descriptions.
SQL: SELECT role_code ,  role_name ,  role_description FROM ROLES

Question: What are all the role codes, role names, and role descriptions?
SQL: SELECT role_code ,  role_name ,  role_description FROM ROLES

Question: What are the name and description for role code "MG"?
SQL: SELECT role_name ,  role_description FROM ROLES WHERE role_code  =  "MG"

Question: Find the name and description of the role with code "MG".
SQL: SELECT role_name ,  role_description FROM ROLES WHERE role_code  =  "MG"

Question: Show the description for role name "Proof Reader".
SQL: SELECT role_description FROM ROLES WHERE role_name  =  "Proof Reader"

Question: What is the description of the role named "Proof Reader"?
SQL: SELECT role_description FROM ROLES WHERE role_name  =  "Proof Reader"

Question: How many employees do we have?
SQL: SELECT count(*) FROM Employees

Question: Find the number of employees we have.
SQL: SELECT count(*) FROM Employees

Question: Show the name, role code, and date of birth for the employee with name 'Armani'.
SQL: SELECT employee_name ,  role_code ,  date_of_birth FROM Employees WHERE employee_Name  =  'Armani'

Question: What are the name, role code, and date of birth of the employee named 'Armani'?
SQL: SELECT employee_name ,  role_code ,  date_of_birth FROM Employees WHERE employee_Name  =  'Armani'