code: def test_sql_select_from_file(self):
      self.sql_via_http("use mindsdb", RESPONSE_TYPE.OK)
      resp = self.sql_via_http(
          "select * from files.test_file", RESPONSE_TYPE.TABLE
      )
      assert len(resp["data"]) == 50
      assert len(resp["column_names"]) == 8
  
      resp = self.sql_via_http(
          "select rental_price, rental_price as rp1, rental_price rp2 from files.test_file limit 10",
          RESPONSE_TYPE.TABLE,
      )
      assert len(resp["data"]) == 10
      assert resp["column_names"] == ["rental_price", "rp1", "rp2"]
      assert (
          resp["data"][0][0] == resp["data"][0][1]
          and resp["data"][0][0] == resp["data"][0][2]
      )
  
imports: from pathlib import Path
  import json
  import requests
  import pandas
  import pytest
  from mindsdb.api.executor.data_types.response_type import RESPONSE_TYPE
  from .conftest import make_test_csv
  from .http_test_helpers import HTTPHelperMixin
label_desc: Use image node_id 13 for calling the TestHTTP obj's underlying member method code with example usage: obj.test_sql_select_from_file() without return types