queries/generate_samples_ex4.sql

queries/generate_samples_ex4.sql#

DROP TABLE IF EXISTS ${td.database}.${td.tbl_aaa};
CREATE TABLE ${td.database}.${td.tbl_aaa} AS
SELECT
  member_id, email, tel, name
FROM
  ( VALUES
     ('1', 'a@ex.com',1111,'Taka')
    ,('2', 'a@ex.com',2222,'Tatsuo')
    ,('3', 'b@ex.com',3333,'Naruse')
    ,('3', 'b@ex.com',4444,'Yuichiro')
    ,(NULL,'c@ex.com',5555,'Minero')
    ,(NULL,'c@ex.com',6666,'Kaz')
  ) AS t(member_id, email, tel, name);