Using a Case statement IN where clause
<p>Problem: When category= books &amp; FMCG then shipping_cost less then selling_price else no check.. Please suggest..:)</p>

<p>Actual Condition:  WHERE
    a.shipping_cost &lt; a.selling_price</p>

<p>Expected Condition: WHERE
    CASE WHEN a.category IN('Books','FMCG') then a.shipping_cost &lt; a.selling_price END</p>