Dear Experts

SELECT AVLBOOK
SUM For Mode='B' BAGS To B
SUM For Mode='L' BAGS To L

I want to use above lines in SELECT statement
I wrote follwing lines but do not work please modify

SELECT *;
	FORM AVLBOOK;
	SUM(IIF(BAGS,Mode="B",1,0)AS B;
	SUM(IIF(BAGS,Mode="L",1,0)AS L;
	ORDER BY ACC_NO;
	GROUP BY ACC_NO;
	INTO CURSOR XYZ

Field Bags is numeric
Filed Mode is character

please help