Percent of Late Orders

You have access to an orders table with the following structure: Column Name Type order_id int order_time datetime delivery_time datetime order_id serves as the primary key. Every row represents a single order and captures the timestamp when it was placed and when it was delivered. Your task is to determine what percentage of orders are classified as late. A late order is defined as one whose delivery required more than 15 minutes from the moment the order was placed. The…