examine the structure of the transactions table

Which query gives the required result?