question: What are the lot details of lots associated with transactions whose share count is bigger than 100 and whose type code is "PUR"?
#1 return transactions 
#2 return share counts of  #1 
#3 return #1 where #2 is  higher than 100 
#4 return type codes of  #1 
#5 return #1 where #4 is  PUR 
#6 return #1 of  both #3 and  #5 
#7 return lots associated with #6 
#8 return lot details of  #7