Show the average share count of transactions each each investor, ordered by average share count.
CREATE TABLE TRANSACTIONS (
    investor_id VARCHAR,
    share_count INTEGER
)
SELECT investor_id, AVG(share_count) FROM TRANSACTIONS GROUP BY investor_id ORDER BY AVG(share_count)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the average share count of transactions each each investor, ordered by average share count. ### Input: CREATE TABLE TRANSACTIONS (
    investor_id VARCHAR,
    share_count INTEGER
) ### Response: SELECT investor_id, AVG(share_count) FROM TRANSACTIONS GROUP BY investor_id ORDER BY AVG(share_count)