USE zerobase;
DESC celeb;
SELECT name, age FROM celeb WHERE age=29 ORDER BY age;
SELECT name, age FROM celeb WHERE age!=29 ORDER BY age;
SELECT name, age FROM celeb WHERE age>29 ORDER BY age;
SELECT name, age FROM celeb WHERE age<29 ORDER BY age;
SELECT name, age FROM celeb WHERE age>=29 ORDER BY age;
SELECT name, age FROM celeb WHERE age<=29 ORDER BY age;
SELECT name, age FROM celeb WHERE age<>29 ORDER BY age;
위 글은 제로베이스 데이터 취업 스쿨의 강의자료를 참고하여 작성되었습니다.