โ† Practo questions

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.