Show the lot details of all lots.
select lot_details from lots
Show the ids of investors with details "l".
select investor_id from investors where investor_details = "l"
Return the lot details of lots that belong to investors with details "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"