The SQL Behind This Dashboard

This data is queried live from PostgreSQL on Supabase. Here's the exact query powering the bookings table above:

SELECT
    b.booking_ref,
    p.name        AS property_name,
    p.location    AS property_location,
    g.full_name   AS guest_name,
    g.email       AS guest_email,
    b.checkin_date,
    b.checkout_date,
    (b.checkout_date - b.checkin_date)             AS num_nights,
    (b.num_adults + b.num_kids)                    AS total_guests,
    (b.checkout_date - b.checkin_date)
        * b.price_per_night                        AS total_amount,
    b.status,
    b.created_at
FROM bookings b
JOIN properties p ON p.id = b.property_id
JOIN guests    g ON g.id  = b.guest_id
ORDER BY b.created_at DESC;