Can you show me a list of all of the lots that belong to category 'i' within the 'lot details' column?
select * from lots where lot_details = "i"
My apologies!  I mean ask for "l" or lower-case L...  Therefore, can you list the lots that belong to category "l" in the 'lot details' column?
select * from lots where lot_details = "l"
Oh sorry!  I am all mixed up!  Third time's a charm!  Can you provide me with the lot details for all lots that belong to investors which belong to the 'investor id' category of "l"?
select t2.lot_details from investors as t1 join lots as t2 on t1.investor_id = t2.investor_id where t1.investor_details = "l"
Excellent! Can you list the investor IDs that correspond to each of these lot_details?
select t1.investor_id, t2.lot_details from investors as t1 join lots as t2 on t1.investor_id = t2.investor_id where t1.investor_details = "l"