title: How can i get count of number of rows that have boolean value true(or 1) in Room persistent database without using SELECT query?
body: <p>I am working with Room persistent database in my project. I have a table in which there is a column for Boolean values as in 0 or 1, now i want the count of all Boolean values whose value is true (or 1). </p>
  
  <p>I know that i can achieve this using select query by getting the count of all selected rows using where clause!</p>
  
  <p>But i don't want to use Select query with where clause for this because it will load all the rows and then i will get the count, but i want the count without loading any rows! Suggest other simple solutions please! Thank you!</p>