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

Show the ids and details of the investors who have at least two transactions with type code 'SALE' Plot them as bar chart, I want to rank by the bar in ascending please.
SELECT T1.Investor_details, T1.investor_id FROM Investors AS T1 JOIN Transactions AS T2 ON T1.investor_id = T2.investor_id WHERE T2.transaction_type_code = "SALE" ORDER BY T1.Investor_details
SELECT "T1"."Investor_details", "T1"."investor_id" FROM "Investors" AS "T1" JOIN "Transactions" AS "T2" ON "SALE" = "T2"."transaction_type_code" AND "T1"."investor_id" = "T2"."investor_id" ORDER BY "T1"."Investor_details" NULLS FIRST