Untitled
unknown
mysql
13 days ago
487 B
1
Indexable
Never
-- Transactional level detail for New Business and Renewal SELECT Transaction_Date, Transaction_Type, Agency_ID, State, Class, Channel, Product, GWP, Terrorism_Levy, FSL, GST, Stamp_Duty, Commission, Commission_GST, Accounting_Month FROM transactions WHERE Transaction_Type IN ('New Business', 'Renewal') AND Accounting_Month = '2024-08-01'; -- Replace with the required accounting month
Leave a Comment