Convert query('SELECT COUNT(*) FROM ...') to select('...')->countQuery() in tests (step 2)

Problem/Motivation

There are a lot of calls to db_query('SELECT COUNT(*) ...');.

Find for example just those in test code with find . -type f -name '*Test.php' -exec grep -Ei "QUERY.*COUNT.*\(\*\)" {} \+.

There's a better and more db abstract way to achieve the same with $injected_database->select(...)->countQuery()

Proposed resolution

Convert those to $injected_database->select(...)->countQuery() in test code. Followup of #2994904: Convert query('SELECT ... FROM {xxx}') to select('xxx')->... in tests for remaining tests.

Remaining tasks

User interface changes

API changes

Data model changes