insert all record into table1 from table2 using where like clause
If you want all rows from table1 to be inserted into table2 (and only some modifications in column t000) then you can't use WHERE. You could use a CASE expression:

INSERT INTO table2
  ( ID, Metrics, t000 )
SELECT 
    ID, Metrics, CASE WHEN t000 LIKE '%BTC%' THEN t000 ELSE 'N/A' END
FROM
    table1 ;




If you want only rows that have t000 LIKE '%BTC%' or t1000 is NULL then yes, you need a WHERE clause::

INSERT INTO table2
  ( ID, Metrics, t000 )
SELECT 
    ID, Metrics, COALESCE(t000, 'N/A')
FROM
    table1 
WHERE 
  ( t000 LIKE '%BTC%' OR t1000 IS NULL ) ;