# Applying Advanced SQL for Analytical Insights - Growth Accounting, Survivorship Analysis, and Smoothing Trends (Day 1 Lab) 

> In this lab, we apply advanced SQL queries to solve analytical challenges and gain insights from datasets, focusing on Growth Accounting, Survivorship analysis using J curves, and smoothing out trend lines.

- Web page: https://julie.techexpert.io/lesson/analytical-patterns-day-1-lab-v2
- Program: [Data Engineering Boot Camp V2 Combined Track](https://julie.techexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 3: Analytical Patterns & Analysis in Postgres (v2)
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 45 min video
- Skills: SQL, Statistics
- Academy: Julies academy to catch all other programs

## About this lesson

In this lab, we apply advanced SQL queries to solve analytical challenges and gain insights from datasets, focusing on Growth Accounting, Survivorship analysis using J curves, and smoothing out trend lines.

## Navigation

- Previous lesson: [Flink Streaming - Real-Time Data Processing Essentials: Lambda vs Kappa Architectures, UDFs, and Windowing Techniques (Day 2 Lecture)](https://julie.techexpert.io/lesson/infra-flink-streaming-day-2-lecture-v2.md)
- Next lesson: [Flink Streaming - Analyzing TechCreator.io Popularity with Flink: Tumbling Windows for Real-Time Traffic Insights (Day 2 Lab) ](https://julie.techexpert.io/lesson/infra-flink-streaming-day-2-lab-v2.md)