987018 wrote:What part of breaking down the brackets to the individual statements are you having difficulty with?
so 1,0 are part of decode or sum??
and if they belongs to decode then either 1 or 0 will be return at a time??Yes, a 1 or 0 for each row depending on the condition. The SUM will then sum up the 1's and 0's to give you a count of those rows that meet the condition.