Changes between Version 4 and Version 5 of AnalyticalStatisticalQuerying


Ignore:
Timestamp:
02/15/25 10:49:00 (2 months ago)
Author:
221164
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AnalyticalStatisticalQuerying

    v4 v5  
    9696}}}
    9797
    98 **Revenue Split: Online vs Tab Orders**
    99 {{{
    100 SELECT
    101     'Online Orders' AS order_type,
    102     SUM(p.amount) AS total_revenue
    103 FROM orders o
    104 JOIN payments p ON o.id = p.order_id
    105 JOIN online_orders oo ON o.id = oo.order_id;
    106 
    107 SELECT
    108     'Tab Orders' AS order_type,
    109     SUM(p.amount) AS total_revenue
    110 FROM orders o
    111 JOIN payments p ON o.id = p.order_id
    112 JOIN tab_orders tord ON o.id = tord.order_id;
    113 }}}
    114 
    11598**Average Shift Duration per Manager**
    11699{{{