code: def join_ever_delinq_features(everdf_tmp, delinq_merge, **kwargs):
      chronometer = Chronometer.makeStarted()
      tables = {"everdf": everdf_tmp, "delinq": delinq_merge}
      query = """
          SELECT everdf.loan_id as loan_id, ever_30, ever_90, ever_180,
              COALESCE(delinquency_30, DATE '1970-01-01') as delinquency_30,
              COALESCE(delinquency_90, DATE '1970-01-01') as delinquency_90,
              COALESCE(delinquency_180, DATE '1970-01-01') as delinquency_180
          FROM main.everdf as everdf LEFT OUTER JOIN main.delinq as delinq
          ON everdf.loan_id = delinq.loan_id
      """
      result_merge = pyblazing.run_query(query, tables)
      Chronometer.show(chronometer, "Create ever deliquency features")
      return result_merge
  
imports: import time
  import pandas
  import pyblazing
  from pyblazing import DriverType, FileSystemType
  from sklearn.model_selection import train_test_split
  import xgboost
  from Configuration import Settings
  from DataBase import createSchema
  from DemoTest.chronometer import Chronometer
  from Utils import Execution
label_desc: Use image node_id 10 for calling a global function with example usage: join_ever_delinq_features(everdf_tmp, delinq_merge) and returns: result_merge