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

Find the transaction type descriptions and dates if the share count is smaller than 10, group by transaction type, count the date of transaction, and bin the date into the weekday interval Show the result with a grouping line chart, and order by the x axis in descending.
SELECT T2.date_of_transaction, COUNT(T2.date_of_transaction) FROM Ref_Transaction_Types AS T1 JOIN Transactions AS T2 ON T1.transaction_type_code = T2.transaction_type_code WHERE T2.share_count < 10 GROUP BY transaction_type_description ORDER BY date_of_transaction DESC
SELECT "T2"."date_of_transaction", COUNT("T2"."date_of_transaction") FROM "Ref_Transaction_Types" "T1" JOIN "Transactions" "T2" ON "T1"."transaction_type_code" = "T2"."transaction_type_code" AND "T2"."share_count" < 10 GROUP BY "transaction_type_description" ORDER BY "date_of_transaction" DESC