solulubeta
Sign in
SQL / Subqueries & CASE
05.11 · SQL

Minimum bill

The store has a minimum bill of ₹500. For every sale return sale_id, total_price and amount_billed: the larger of total_price and 500.

Medium 3 min Pro

This lesson is part of solulu Pro

The store has a minimum bill of ₹500. For every sale return sale_id, total_price and amount_billed: the larger of total_price and 500.

Sign in to continue See plans
Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 55 of 77 · updated 2026-10-12