# Pages Visited

We're still working at devils.fyi, a website similar to levels.fyi.

We've showed our investors how many users have uploaded their salary information.
We also want to show them how many pages get viewed each day in 2022.
For this, we have site analytics stored in the `sessions`

table.

column_name | type |
---|---|

id | UUID |

pages_visited | INTEGER |

referer | VARCHAR |

started_at | DATE |

A session represents a continuous sequence of pages visited by a viewer.
If a user visits the home page, clicks a link to another page on the site,
and then from that page clicks another link, they have visited 3 pages in their session so far.
The session ends when they close the browser tab.
The `pages_visited`

column tells us how many pages the viewer visited in each session.

Investors want a way to measure the popularity of the site over time. They like to see a time series graph of how many sessions there were each day, as well as the number of pages visited each day.

**Generate the growth report for your investors by selecting:**

- The date,
`started_at`

. - The count of the sessions each day (name that
`total_sessions`

). - The total number of pages visited each day (name that
`total_pages_visited`

).

Remember that we only want 2022 data for this report. Also, sort the result by the date in ascending order.

Note: I haven't taught you the aggregate function for summing numbers yet. You'll have to look it up yourself, perhaps using Google.