I have a file which has data like this
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Insert completed. 5 rows added.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Insert completed. 10 rows added.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. One row found.
*** Query completed. No rows found.
*** Query completed. One row found.
I want to sum all the rows found i.e. The total sum should be 47.
For now I am using
awk '/\*\*\* Insert completed. | \*\*\* Query completed./ { SUM += $4 } END { printf ("Rows inserted: %d \n", SUM) }' file
But with this, it is skipping the 'One'. I am trying to equate One to 1. Please let me know how we can do this?