[SELECT/LEVEL1] 특정 형질을 가지는 대장균 찾기 (MySQL)

MySQL

SELECT COUNT(ID) AS COUNT
FROM ECOLI_DATA
WHERE GENOTYPE & 2 = 0
  AND (GENOTYPE & 4 >= 1 OR GENOTYPE & 1 >= 1);