title: Applying different condition on the same column in bigquery
body: <p>I have an input table. I need to get the output based on a few conditions.</p>
  <ol>
  <li>If Type =&quot;Deposit&quot; then Output = Value</li>
  <li>If Type =&quot;Card&quot; and Condition in(&quot;approved&quot;,&quot;approved:conditionally&quot;) then Output = Value,
  If Type =&quot;Card&quot; and Condition = &quot;referred&quot; then Output = 0.4*Value.</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/37on7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/37on7.png" alt="enter image description here" /></a></p>