What are all of the lots?
select * from lots
The id of the lots please.
select lot_id from lots except select t1.lot_id from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.lot_id
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