[프로그래머스, 301647] 부모의 형질을 모두 가지는 대장균 찾기 (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/301647

프로그래머스

---

select my.id as id, my.genotype as genotype, p.genotype as parent_genotype
from ecoli_data as my
left join ecoli_data as p
on my.parent_id = p.id
where bin(my.genotype & p.genotype) = bin(p.genotype)
order by my.id;