What is the minimum share count of the transaction type code PUR?
SELECT share_count  FROM TRANSACTIONS  where transaction_type_code  =  'PUR' and share_count ! =  "" order by share_count limit 1
minimum share count = MIN(share_count); transaction type code PUR refers to transaction_type_code = 'PUR'; excluding empty share counts refers to share_count != '';