> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt # SQL tutorials Canonical URL: https://posthog.com/docs/sql/tutorials Got a question which isn't answered below? Head to [the community forum](https://posthog.com/questions.md) to let us know! > Check [our product analytics tutorials](https://posthog.com/docs/product-analytics/tutorials.md) for more information about analyzing events. ## Examples - [How to do time-based breakdowns (hour, minute, real time) in HogQL](https://posthog.com/tutorials/time-breakdowns.md) - [The power of SQL's sum() aggregation](https://posthog.com/tutorials/hogql-sum-aggregation.md) - [Using SQL for advanced time and date filters](https://posthog.com/tutorials/hogql-date-time-filters.md) - [Using SQL for advanced breakdowns](https://posthog.com/tutorials/hogql-breakdowns.md) - [How to filter and breakdown arrays with SQL](https://posthog.com/tutorials/array-filter-breakdown.md) - [How to use Recharts to visualize analytics data](https://posthog.com/tutorials/recharts.md) - [How to use React Charts to visualize analytics data (with examples)](https://posthog.com/tutorials/react-charts.md) ## Analyzing events - [How to analyze autocapture events with SQL](https://posthog.com/tutorials/hogql-autocapture.md) - [How to analyze first and last touch attribution](https://posthog.com/tutorials/first-last-touch-attribution.md) - [How to calculate time on page with SQL](https://posthog.com/tutorials/time-on-page.md) - [How to calculate bounce rates with SQL](https://posthog.com/tutorials/bounce-rate.md)