How to write nested CASE statements in MySQL Query with Example

how to write stored procedure

in the situation if business table have column like  empid int, custtype varchar,dealertype varchar,photographertype varchar, sal int,

employee belong either custtype or dealertype or photographertype

i want show the result as if

if i fetch the data from business  table my out put should as