What are the lot details of lots associated with transactions whose share count is bigger than 100 and whose type code is 'PUR'?
CREATE TABLE TRANSACTIONS (
    transaction_id VARCHAR,
    share_count VARCHAR,
    transaction_type_code VARCHAR
)

CREATE TABLE TRANSACTIONS_LOTS (
    transaction_id VARCHAR
)

CREATE TABLE LOTS (
    lot_details VARCHAR,
    lot_id VARCHAR
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the lot details of lots associated with transactions whose share count is bigger than 100 and whose type code is 'PUR'? ### Input: CREATE TABLE TRANSACTIONS (
    transaction_id VARCHAR,
    share_count VARCHAR,
    transaction_type_code VARCHAR
)

CREATE TABLE TRANSACTIONS_LOTS (
    transaction_id VARCHAR
)

CREATE TABLE LOTS (
    lot_details VARCHAR,
    lot_id VARCHAR
) ### Response: 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"