human
Schema:
Investors (investor_id, Investor_details)
Lots (lot_id, investor_id, lot_details)
Ref_Transaction_Types (transaction_type_code, transaction_type_description)
Transactions (transaction_id, investor_id, transaction_type_code, date_of_transaction, amount_of_transaction, share_count, other_details)
Sales (sales_transaction_id, sales_details)
Purchases (purchase_transaction_id, purchase_details)
Transactions_Lots (transaction_id, lot_id)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the maximum share count of all of the different transaction type codes?
assistant
SELECT transaction_type_code , MAX( share_count ) FROM TRANSACTIONS GROUP BY transaction_type_code;
human
What is the minimum share count of the transaction type code PUR?
assistant
SELECT share_count FROM TRANSACTIONS WHERE transaction_type_code = 'PUR' AND share_count ! = '' ORDER by share_count LIMIT 1;
human
What is the share count of transaction id 2?
assistant
SELECT share_count FROM TRANSACTIONS WHERE transaction_id = 2 ;