CREATE TABLE Sales (sales_transaction_id NUMBER, sales_details VARCHAR2)
CREATE TABLE Transactions_Lots (transaction_id NUMBER, lot_id NUMBER)
CREATE TABLE Investors (investor_id NUMBER, Investor_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)
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)

What are the number of the dates of transactions with at least 100 share count or amount bigger than 100?, and show total number in desc order.
SELECT date_of_transaction, COUNT(date_of_transaction) FROM Transactions WHERE share_count >= 100 OR amount_of_transaction >= 100 ORDER BY COUNT(date_of_transaction) DESC
SELECT "date_of_transaction", COUNT("date_of_transaction") FROM "Transactions" WHERE "amount_of_transaction" >= 100 OR "share_count" >= 100 ORDER BY COUNT("date_of_transaction") DESC