Perfect!  Could you tell me which payment ID over $5.00 has the most recent payment date?
SELECT payment_id FROM payment where amount>5  ORDER BY last_update DESC LIMIT 1
payment ID over $5.00 refers to amount > 5; most recent payment date refers to MAX(last_update);