MYSQL DECLARE VARIABLE

 I couldn't get count for the  below sql query using SET method , Let me know where i wrong. Thanking you.

Here attached my query screenshot below

via Chebli Mohamed