Hi Guys
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