How many transactions have the type code PUR?
select count ( * ) from transactions where transaction_type_code = "PUR"
How many transactions have a share count larger than 50?
select count ( * ) from transactions where share_count >50
What is the least amount of transactions that have both a type code of PUR and a share count larger than 50?
select min ( amount_of_transaction ) from transactions where transaction_type_code = "PUR" and share_count > 50
How many transactions have the type code PUR and a share count larger than 50?
select count ( * ) from transactions where transaction_type_code = "PUR" and share_count > 50