Return the lot details of lots that belong to investors with details "l"?
create table lots (lot_details varchar, investor_id varchar, PRIMARY KEY (lot_details)); create table investors (investor_id varchar, investor_details varchar, PRIMARY KEY (investor_id))
select t2.lot_details from investors as t1 join lots as t2 on t1.investor_id = t2.investor_id where t1.investor_details = "l"