code: def test_select_and_aggregate(self):
      simple_aggregate_query = "SELECT COUNT(*), AVG(id) FROM MyVideo;"
      actual_batch = execute_query_fetch_all(
          self.evadb, simple_aggregate_query
      )
  
      self.assertEqual(actual_batch.frames.iat[0, 0], 10)
      self.assertEqual(actual_batch.frames.iat[0, 1], 4.5)
  
imports: import unittest
  from test.util import create_dummy_4d_batches, create_dummy_batches, create_sample_video, create_table, file_remove, get_evadb_for_testing, get_logical_query_plan, load_functions_for_testing, shutdown_ray
  import numpy
  import pandas
  import pytest
  from evadb.binder.binder_utils import BinderError
  from evadb.models.storage.batch import Batch
  from evadb.optimizer.operators import LogicalFilter
  from evadb.server.command_handler import execute_query_fetch_all
label_desc: Use image node_id 11 for calling the SelectExecutorTest obj's underlying member method code with example usage: obj.test_select_and_aggregate() without return types