"""
출처:프로그래머스,
https://school.programmers.co.kr/learn/courses/30/lessons/301647
"""
-- bin(): 이진법 변환 -- 
select A.ID,A.GENOTYPE,B.GENOTYPE "PARENT_GENOTYPE"
-- cross join 형식 cross join은 생략 가능! -- 
from ECOLI_DATA A, ECOLI_DATA B
where A.PARENT_ID = B.ID
and A.GENOTYPE & B.GENOTYPE = B.GENOTYPE
# and cast(bin(A.GENOTYPE) as char) like CONCAT('%', CAST(BIN(B.GENOTYPE) AS CHAR))
order by A.ID