SQL 고득점 Kit - SELECT
·
Programmers/SQL
Contents3월에 태어난 여성 회원 목록 출력하기SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTHFROM MEMBER_PROFILE WHERE GENDER = 'W' AND DATE_OF_BIRTH LIKE '%-03-%'AND TLNO IS NOT NULLORDER BY MEMBER_ID ASC;서울에 위치한 식당 목록 출력하기SELECT R.REST_ID, R.REST_NAME, R.FOOD_TYPE, R.FAVORITES, R.ADDRESS, ROUND(AVG(RV.REVIEW_SCORE), 2) AS SCOREFROM REST_INFO RJOIN REST..