In seats, seat id = 1 has remaining = 1, while several customers try to book it at the same time. Write a statement that reduces remaining by 1 only when the seat is available and prevents double booking.
seats
id = 1
remaining = 1
remaining
1
Sign in to see submission history
Sign in to use AI Mentor
Your query result will appear here