Count by ID if value is lower than and set the value 1 : <p>I have a problem.
My table is <strong>tableXYZ</strong>
I have a row <strong>a</strong> where i set the year.
I have a row <strong>b</strong> where i need to set value 1 if the year from row <strong>a</strong> is lower than 2019 and 0 if is > 2019.</p>

<p>After all i need to make a count from row <strong>b</strong> only the 1 values as total.</p>

<p>How can i do that, because i tried a lot of examples but doesn't work.</p>
