Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE transactions ( transaction_id number, investor_id number, transaction_type_code text, date_of_transaction time, amount_of_transaction number, share_count text, other_details text )
TABLE: CREATE TABLE purchases ( purchase_transaction_id number, purchase_details text )
TABLE: CREATE TABLE lots ( lot_id number, investor_id number, lot_details text )
TABLE: CREATE TABLE transactions_lots ( transaction_id number, lot_id number )
TABLE: CREATE TABLE ref_transaction_types ( transaction_type_code text, transaction_type_description text )
TABLE: CREATE TABLE sales ( sales_transaction_id number, sales_details text )
TABLE: CREATE TABLE investors ( investor_id number, investor_details text )

### Question ###
Show the average share count of transactions each each investor, ordered by average share count.

### Accurate SQL ###

SELECT investor_id, AVG(share_count) FROM transactions GROUP BY investor_id ORDER BY AVG(share_count)