강의로 돌아가기
김나현

[스포주의] mysql

-- 코드를 입력하세요

SELECT A.FLAVOR
FROM FIRSTHALF AS A
INNER JOIN ICECREAM
INFO AS B
ON A.FLAVOR=B.FLAVOR
WHERE A.TOTALORDER>=3000 AND INGREDIENTTYPE LIKE 'fruitbased'
ORDER BY A.TOTAL
ORDER DESC

0 개의 답변
답변 쓰기
This input form supports markdown syntax. Please refer to 마크다운 가이드.