Напредни извештаи од базата (SQL и складирани процедури)

Извештај за откжани резервации по ресторан.

select
    count(rh.cancellation_reason),
    au.first_name, 
    au.last_name, 
    au.membership_level, 
    au."role", 
    rh.cancellation_reason, 
    rh.restaurant_id 
from reservation_history rh  
inner join app_user au on rh.customer_id = au.id 
where rh.cancellation_reason = 'Canceled by user'
group by au.first_name, 
    au.last_name, 
    au.membership_level, 
    au."role", 
    rh.cancellation_reason, 
    rh.restaurant_id 
order by rh.cancellation_reason

select count(r.table_number), r.userid  from reservations r
group by r.userid