What are the details of the lots which aren't used in any transactions?
SELECT lot_details FROM Lots EXCEPT SELECT T1.lot_details FROM Lots AS T1 JOIN transactions_lots AS T2 ON T1.lot_id   =   T2.lot_id
lots not used in any transactions refers to a set difference operation; details of the lots refers to selecting lot_details;