Adding a condition using SQL or an ABAP program and difference in performance

As there are just 500, there would not be much difference among both options. You can use either of them.

The ABAP code is as below −

LOOP AT lt_table TRANSPORTING NO FIELDS WHERE exp > 5
   ADD 1 TO lt_counter
ENDLOOP