I have a table named earned_trans with three columns [msisdn],[claim_date], [claim_type]
Please help me to write the query for this(bascially a stored procedure)
So here i have to get the claim_date using msisdn
select claim_date, claim_type where msisdn='1233'
and with this
if claim_date == null
then set result = "absent"
elseif claim_date != null
then if(claim_type == "bank")
then set result = "bank"
elseif(claim_type == "claim")
then set result = "claim"
Please help me to write this query