db.l3.ai

Play

lessons

upsert-drills

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Share of bookings with guests

A share is a numerator over a denominator. Both are aggregates, so one query can compute both. In Postgres 7 / 2 is 3: integer division drops the fraction.

task

What percent of bookings brought at least one guest? One column, percent_with_guests, rounded to one decimal.

hints