CREATE TABLE INVESTORS (investor_id VARCHAR2, Investor_details VARCHAR2)
CREATE TABLE LOTS (lot_details VARCHAR2, investor_id VARCHAR2)

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"
SELECT "T2"."lot_details" FROM "INVESTORS" "T1" JOIN "LOTS" "T2" ON "T1"."investor_id" = "T2"."investor_id" WHERE "T1"."Investor_details" = "l"