Changes between Version 9 and Version 10 of AnalyticalStatisticalQuerying


Ignore:
Timestamp:
09/27/25 14:33:03 (2 weeks ago)
Author:
221507
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AnalyticalStatisticalQuerying

    v9 v10  
    256256If we purchase 3 tickets:
    257257
    258 
    259258[[Image(purchase.png)]]
    260259
     
    299298    t.price AS discounted_price,
    300299    ct.discount,
    301         tr.base_price AS original_price
     300    tr.base_price AS original_price
    302301FROM ticket t
    303302JOIN child_ticket ct ON ct.ticket_id = t.ticket_id
     
    306305
    307306''We will get the following results:''
     307
    308308[[Image(child_ticket_prices.png)]]
    309309