# モデルを使用して予測
SELECT
  *
FROM ML.PREDICT(
  MODEL DE.mdl_members_cls
  ,(
    SELECT
      *
    FROM DE.sum_members_cls_non
    WHERE
      gender = 1
      AND is_buy_clothing　= 0
      AND is_buy_toy　= 0
      AND is_buy_sports　= 0
      AND is_buy_home　= 0
      AND is_buy_beauty　= 0
      AND is_buy_books　= 0
      AND is_buy_automotive　= 0
      AND is_buy_movies　= 0
      AND is_buy_electronics　= 1
  )
)