thecss/food-delivery-promotion-analysis ? reverse-engineered prompt

Build me a small SQL based analytics project for a food delivery app that helps decide which restaurants and cuisines to feature in in app promotions.

I want it to analyze order data from New York City, check the data for issues like missing values, duplicates, invalid times or costs, and unrated orders, then summarize customer demand, ratings, order value, prep time, and delivery time. Please include clear findings for the best performing restaurants and cuisines, plus a simple recommendation section that points out the strong candidates for promotion and the hidden gems with great ratings but lower order counts.

Also make the results easy to read in a report style format, with a concise executive summary and supporting documentation. If you need to, look up current SQL best practices online.