Command sql query

ลูกค้าที่ Create ตั้งแต่ Jan 1 และมีการสั่งซื้อสินค้าและจ่ายเงินแล้ว SELECT inv.id,cus.create_dt,cus.fullname,dm.domain,pdn.name,invp.unit,invp.price_per_unit,invp.price FROM `tb160_invoice_product` invp LEFT JOIN `tb11_customer` cus ON cus.no = invp.customer_no LEFT JOIN `tb164_product_name` pdn ON invp.product_name_no = pdn.no LEFT JOIN `tb159_invoice` inv on invp.invoice_no = inv.no LEFT JOIN `tb172_invoice_product_package` dm on invp.invoice_no = dm.invoice_no WHERE cus.create_dt > '2023-01-01' and inv.invoice_type = 'new' and inv.paid_status = 2 and (pdn.`type_no` = 1 AND (pdn.group_name in ('Go Cloud (Fixed User)','Go Cloud (Private Server)','Go Cloud (Unlimited User)')) or (pdn.name in ('Hybrid Email Go Cloud 200 GB (Fixed Disk)','Hybrid Email Go Cloud 3 GB (Fixed User)','Hybrid Email Go Cloud 5 GB (Fixed User)','Hybrid Email Go Cloud 5 GB (Fixed User)','Hybrid Email Go Cloud 7 GB (Fixed User)','Hybrid Email Go Cloud 10 GB (Fixed User)'))) ORDER BY cus.create_dt ASC ลูกค้าทั้งหมดที่ไม่มีสินค้าหมวดข้อ 3 (Domain)แต่มีสินค้า-1.1-1.2-1.3 SELECT DISTINCT inv.no,inv.id,inv.invoice_type,inv.create_date,pdn.name,cus.fullname,dm.domain,inv.grand_total,pay.payment_date,con.id,con.end FROM `tb160_invoice_product` invp LEFT JOIN `tb164_product_name` pdn ON pdn.no = invp.product_name_no LEFT JOIN `tb159_invoice` inv ON inv.no = invp.invoice_no LEFT JOIN `tb11_customer` cus ON cus.no = invp.customer_no LEFT JOIN `tb175_payment_invoice` pay ON pay.invoice_no = invp.invoice_no LEFT JOIN `tb162_contract_product` con on invp.no = con.invoice_product_no LEFT JOIN `tb172_invoice_product_package` dm on invp.invoice_no = dm.invoice_no WHERE inv.status = 'active' and invp.invoice_no in (SELECT invoice_no FROM `tb160_invoice_product` invp LEFT JOIN `tb164_product_name` pdn ON pdn.no = invp.product_name_no WHERE status = 'active' and pdn.group_name in ('Go Cloud (Fixed User)','Go Cloud (Private Server)','Go Cloud (Unlimited User)')) AND pdn.type_no = 1 Domain ทั้งหมดที่ใช้สินค้า 1.6 SELECT dm.domain,pdn.name FROM `tb162_contract_product` con LEFT JOIN `tb11_customer` cus ON cus.no = con.customer_no LEFT JOIN tb73_domain dm ON con.contract_product_package_no = dm.no LEFT JOIN `tb164_product_name` pdn ON pdn.no = con.product_name_no WHERE product_name_no in (459,460,461,462,465,490,491,492,493) GROUP BY dm.domain