SQL query to add hsn code ,sales qty itemwise & GST Tax rate(if IGST

Hi expert,

can any one help me to get product HSN code , Sales qty item wise and GST rate (if iterState or IntraState) on my existing sales register. My sales register at summary level.

can you pls share the proper query can be used to get below column data from order & AR module;

                                

1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32
JE_CATEGORYNAME	PERIOD NAME	Tax Invoice No	Ar Invoice No	Ar Invoice Date	Customer No	Party Name	Ship to State	Bill to State	CustomerGST No	Currency Code	Domestic Sale	Export Sale	Foreign Curr Amt	Misc . Income	Commission amount	Net Sale	FREIGHT	Assessabl Value	IGST	IGST_Fun_Currency