Astra Tech interview question

Building a fullstack app in a live coding round with focus on both frontend (UI) and backend (REST API design, SQL and interacting with the database for a CRUD operation) followed by general SQL based questions for ranking and optimised updates to a large dataset.