SELECT

    h.SalesOrderID as test,

    test *test as Test2

  FROM tb_salesOrderHeader h ;

  SELECT

    CASE p.ProductTopCategory

    WHEN 'Clothing'

      THEN

        CASE WHEN d.OrderQty >= 10

          THEN 0.10

        WHEN d.OrderQty >= 5

          THEN 0.05

        ELSE 0

        END

    WHEN 'Accessories'

      THEN

        CASE WHEN d.OrderQty >= 10

          THEN 0.11

        WHEN d.OrderQty >= 5

          THEN 0.04

        ELSE 0

        END

    ELSE 0

    END AS Discount,

    d.OrderQty AS Quantity,

    p.ListPrice - Discount AS LineTotal

  FROM tb_salesOrderDetail d

    JOIN tb_salesOrderHeader h ON h.SalesOrderID = d.SalesOrderID

    JOIN tb_shipMethod shipMethod ON shipMethod.ShipMethodID = h.ShipMethodID

    JOIN bi_olap_22.product p ON d.ProductID = p.ProductID

    JOIN bi_olap_22.location l ON h.ShipToAddressID = l.AddressID ;