Piezo not making sound
As Majenko pointed out, the wires are not connected to the piezo.  By moving the piezo to the correct rails on the other side of the board, the circuit would be completed and the piezo should work.

Edit: 
Building on Nick Gammon's comment, the rows of each side of a breadboard are not connected (to allow DIP packages).