Your task

Write one query per page. Save them in data/queries/sql/05-the-feed.sql.

1. Poke around. Look at every table once so you know what you're working with.

2. Homepage. The 5 newest published posts: title, author's username, and when it was posted. Drafts must never appear.

3. Homepage, page 2. The next 5.

4. Profile page. Every post by alice, newest first, drafts included (she's looking at her own profile). Find her by username, not by typing her id.

5. Search. Published posts whose title mentions postgres, in any capitalization.

6. Post page. The comments on post 1, oldest first, each with the commenter's username.

7. Tag page. Published posts tagged sql, newest first.

8. Following feed. Published posts written by the people dev follows, newest first, with the author's username.