[SQL] Walmart's Same-Day Orders

select distinct user_id, 
    count(*) over (partition by user_id) total_n_order,
    count(*) over (partition by order_date) total_value
from order_summary
where user_id IN (
    select os.user_id
    from order_summary os
        join sessions ss
        on os.user_id = ss.user_id
    where ss.session_date = os.order_date
    )
order by user_id