Mysql returns incorrect data with use of join

Mysql returns incorrect data with use of join

I have join with a multiple tables you can find the tables and mysql query
in this demo. You can see the output of this query and instead of that i
want following output
id NAME AMOUNT NO_COMMON_BILLS
2 XYZ 100 2
3 PQR 300 1
I am getting wrong output at NO_COMMON_BILLS other than all values are
correct.
Thank you