Three-Flower Bouquet Costs

Problem

A florist stocks single stems in `Stems`, each with a per-stem `price`. A signature bouquet uses exactly **three different stems**. List the cost of every possible three-stem bouquet. Within each bouquet the stem names must appear in alphabetical order, separated by commas, and no stem may repeat. Output `bouquet` (the comma-joined names) and `total_price` (the rounded sum of the three prices, to 2 decimals). Order by `total_price` descending, then `bouquet` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns bouquet, total_price.

Starter code (SQL)

SELECT *
FROM Stems;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium