(select) is not null, like, date_format

3월에 태어난 여성 회원 목록 출력하기

내풀이

SELECT  member_id, 
		member_name, 
        gender, 
        date_format(date_of_birth, '%Y-%m-%d') as date_of_birth 
from member_profile 
where date_of_birth like "%-03-%" 
	  and gender like "%W%" 
      and tlno is not null 
order by member_id asc;