You should post this in a mySQL forum.
I want the value inside 'success_count' against individual 'brand_code', which lie within the last 7 days from the current date.
. . .
It is not clear why you would only get the two rows you want when there are other rows that 'lie within the last 7 days'.
Please mark this thread ANSWERED and repost in an appropriate forum.