What is the lowest share count?
SELECT share_count FROM TRANSACTIONS where share_count ! =  "" order by share_count limit 1
lowest share count refers to MIN(share_count); excluding empty values is done by WHERE share_count != '';