🔗 여러 기준으로 정렬하기🦈 MySQL, Oracle ⭕️SELECT ANIMAL_ID , NAME , DATETIMEFROM ANIMAL_INSORDER BY NAME ASC, DATETIME DESC;

🔗 특정 물고기를 잡은 총 수 구하기🦈 MySQL 🦈SELECT COUNT(ID) AS FISH_COUNTFROM FISH_INFO IJOIN FISH_NAME_INFO NON I.FISH_TYPE = N.FISH_TYPEWHERE FISH_NAME IN ('BASS', 'SNAPPER')

🔗 가장 큰 물고기 10마리 구하기🦈 MySQL 🦈SELECT ID, LENGTHFROM FISH_INFOORDER BY LENGTH DESC, ID ASCLIMIT 10;

🔗 잔챙이 잡은 수 구하기🦈 MySQL 🦈SELECT COUNT(ID) AS FISH_COUNTFROM FISH_INFOWHERE LENGTH IS NULL;

🔗 FrontEnd 개발자 찾기🦈 MySQL 🦈SELECT DISTINCT D.ID , D.EMAIL , D.FIRST_NAME , D.LAST_NAMEFROM DEVELOPERS DJOIN SKILLCODES CON C.CODE & D.SKILL_CODE = C.CODEWHERE C.CATEGORY = 'Front End'ORDER BY D.ID ASC;

🔗 조건에 맞는 도서와 저자 리스트 출력하기🦈 MySQL 🦈SELECT B.BOOK_ID , A.AUTHOR_NAME , DATE_FORMAT(B.PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATEFROM BOOK BJOIN AUTHOR AON B.AUTHOR_ID = A.AUTHOR_IDWHERE B.CATEGORY = '경제'ORDER BY B.PUBLISHED_DATE ASC; ⭕️ Oracle ⭕️SELECT B.BOOK_ID , A.AUTHOR_NAME , TO_CHAR(B.PUBLISHED_DATE, 'YYYY-MM-DD') AS PUBLISHED_DATEFROM BOOK BJOIN AUTHOR AON B.AUTHOR_ID = A.AUT..

🔗 서울에 위치한 식당 목록 출력하기🦈 MySQL 🦈SELECT I.REST_ID , I.REST_NAME , I.FOOD_TYPE , I.FAVORITES , I.ADDRESS , ROUND(AVG(R.REVIEW_SCORE), 2) AS SCOREFROM REST_INFO IJOIN REST_REVIEW RON I.REST_ID = R.REST_IDWHERE I.ADDRESS LIKE '서울%'GROUP BY I.REST_IDORDER BY SCORE DESC, I.FAVORITES DESC; ⭕️ Oralce ⭕️SELECT I.REST_ID , I.REST_NAME , I.FOOD_TYPE , I.FAVORITES , I.ADDRESS ..

🔗 3월에 태어난 여성 회원 목록 출력하기🦈 MySQL 🦈✨ 방법1 : DATE_FORMAT ✨SELECT MEMBER_ID , MEMBER_NAME , GENDER , DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d")FROM MEMBER_PROFILEWHERE GENDER = 'W' AND MONTH(DATE_OF_BIRTH) = 3 AND TLNO IS NOT NULLORDER BY MEMBER_ID ASC; 🌟 방법2 : LIKE 🌟SELECT MEMBER_ID , MEMBER_NAME , GENDER , DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d")FROM MEMBER_PROFILEWHERE GENDER..

🔗 과일로 만든 아이스크림 고르기🦈 MySQL, Oracle ⭕️SELECT F.FLAVORFROM FIRST_HALF FJOIN ICECREAM_INFO ION F.FLAVOR = I.FLAVORWHERE F.TOTAL_ORDER > 3000 AND I.INGREDIENT_TYPE = 'fruit_based'ORDER BY F.TOTAL_ORDER DESC;