code: def count_where(self, table: str, wheredict: Dict[str, Any] = None) -> int:
          
          sql = "SELECT COUNT(*) FROM " + self.delimit(table)
          if wheredict is not None:
              sql += " WHERE " + " AND ".join([
                  self.delimit(k) + "=?"
                  for k in wheredict.keys()
              ])
              whereargs = wheredict.values()
              count = self.fetchone(sql, *whereargs)[0]
          else:
              count = self.fetchone(sql)[0]
          return count
docs: Counts rows in a table, given a set of WHERE criteria (ANDed),
          returning a count.