What are the lot details of lots associated with transactions whose share count is bigger than 100 and whose type code is "PUR"?
select t1.lot_details from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count > 100 and t3.transaction_type_code = "PUR"
Which has the highest amount of transaction?
select t1.lot_details from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count > 100 and t3.transaction_type_code = "PUR" order by t3.amount_of_transaction desc limit 1
what was the date of that transaction?
select t3.date_of_transaction from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count > 100 and t3.transaction_type_code = "PUR" order by t3.amount_of_transaction desc limit 1
What  transaction type code did that have?
select t3.transaction_type_code from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count > 100 and t3.transaction_type_code = "PUR" order by t3.amount_of_transaction desc limit 1