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)
CREATE TABLE Ref_Transaction_Types (transaction_type_code VARCHAR, transaction_type_description VARCHAR)
CREATE TABLE Purchases (purchase_transaction_id INT, purchase_details VARCHAR)
CREATE TABLE Lots (lot_id INT, investor_id INT, lot_details VARCHAR)
CREATE TABLE Transactions_Lots (transaction_id INT, lot_id INT)
CREATE TABLE Investors (investor_id INT, Investor_details VARCHAR)
CREATE TABLE Sales (sales_transaction_id INT, sales_details VARCHAR)

Bin all date of transactions into the weekday interval, and compute the average of the share count for each bin Return the result using a bar chart, show in ascending by the total number please.
SELECT date_of_transaction, AVG(share_count) FROM Transactions ORDER BY AVG(share_count)
SELECT "date_of_transaction", AVG("share_count") FROM "Transactions" ORDER BY AVG("share_count") NULLS FIRST