Design a movie booking schema and query it
Filed under Practo
The question
Design a schema with theatres, bookings, customers and movies, then write queries for movies with more than 5 bookings and the second-highest day by transaction count.
No write-up yet. Related questions below have one.
Related Practo questions
Collected from public candidate posts and coding forums. Updated Nov 2026.