CREATE TABLE Lots (lot_id INT, investor_id INT, lot_details VARCHAR)
CREATE TABLE Sales (sales_transaction_id INT, sales_details VARCHAR)
CREATE TABLE Purchases (purchase_transaction_id INT, purchase_details VARCHAR)
CREATE TABLE Investors (investor_id INT, Investor_details VARCHAR)
CREATE TABLE Ref_Transaction_Types (transaction_type_code VARCHAR, transaction_type_description VARCHAR)
CREATE TABLE Transactions_Lots (transaction_id INT, lot_id INT)
CREATE TABLE Transactions (transaction_id INT, investor_id INT, transaction_type_code VARCHAR, date_of_transaction DATETIME, amount_of_transaction DECIMAL, share_count VARCHAR, other_details VARCHAR)

A bar chart for showing the number of the dates of transactions if the share count is bigger than 100 or the amount is bigger than 1000, and sort in asc by the Y please.
SELECT date_of_transaction, COUNT(date_of_transaction) FROM Transactions WHERE share_count > 100 OR amount_of_transaction > 1000 ORDER BY COUNT(date_of_transaction)
SELECT "date_of_transaction", COUNT("date_of_transaction") FROM "Transactions" WHERE "amount_of_transaction" > 1000 OR "share_count" > 100 ORDER BY COUNT("date_of_transaction") NULLS FIRST