DB | [SQL] SQL 실습 내용

select title, content
from post 
order by created_at desc
limit 5;

select * 
from post 
order by created_at asc

-- like '문자열' - '와일드 카드' % include
-- % 어떤 값이 와도 된다.
select * 
from post
where content like '%독서%'

select *
from comment
where post_id in (2, 3, 4)

select count(*)
from comment
where user_id = (
    select user_id
    from user
    where username = 'Alice'
);