db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

count over ()

An empty OVER () is the whole result as one window. It gives totals next to detail rows.

task

Each facility's number of bookings and its percent of all bookings (1 decimal), without a subquery: columns facility_id, count, percent.

hints