MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE tABLE account (ACC_TYPE vaRCHAR(2), CUS_NAME VARCHAR(20))
INSERT INTO account VALUES ('FD','Alex'), ('SA','Alex'), ('SA','Alex')

Records: 3  Duplicates: 0  Warnings: 0


CREATE procedure sp_count_accounts(in inCX varchar(45), out countFD int, out countSA int) 
begin
    #declare countFD, countSA int default 0;  <-- removed
    select count(*) into countFD from account where ACC_TYPE='FD' and CUS_NAME = inCX;
    select count(*) into countSA from account where ACC_TYPE='SA' and CUS_NAME = inCX;
end
CALL sp_count_accounts('Alex', @SA, @FD); 

SELECT @SA as Savings, @FD as 'Fixed Deposit';


Savings
Fixed Deposit


1
2