Orders with Offer Increase

Table: orders > > >order_id uniquely identifies each order. base_offer records the order's starting offer amount. Table: requests > > >Every row in requests represents one attempted offer. For a request, an offer increase exists when its offer_amount is greater than the base_offer of the related order. Return one row containing these two metrics: Percentage of orders with at least one offer increase (pct_orders_with_increase), rounded to 2 decimal places. Average offer…