code: def test_complex_select(self):
      # Select email maintainers table
      sql = f"""
              SELECT email FROM npm_test.maintainers WHERE package='{self.test_package_name}';
          """
      assert self.run_sql(sql).shape[1] == 1
  
      # Select single dependency
      sql = f"""
              SELECT * FROM npm_test.dependencies WHERE package='{self.test_package_name}' LIMIT 1;
          """
      assert self.run_sql(sql).shape[0] == 1
  
file_path: mindsdb/tests/handler_tests/test_npm_handler.py
imports: import importlib
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from ..unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 4 for calling the TestNPMHandler obj's underlying member method code with example usage: obj.test_complex_select() without return types