👉 Oracle SQL Interview Question | Calculate Active Hours Per User Per Day (Real-Time Scenario)

For more updates :-
What's app : +919629219125
Linked in : https://www.linkedin.com/in/raja-sekar-0aa99077/
Youtube : https://www.youtube.com/@rajasekardataengineer

🚀 Oracle SQL Interview Question – Real-Time Scenario

In this video, we solve a very important SQL interview problem:
👉 How to calculate active hours for each user per day based on state changes?

This is a real-world scenario frequently asked in Data Engineer interviews and used in production systems like user activity tracking, sessionization, and analytics.

🧠 Concepts Covered:
- SQL Window Functions (LEAD)
- Timestamp Difference Calculation
- Sessionization Logic
- Group By Aggregation

📊 Problem Statement:
Given a dataset with:
custid | state (1=active, 0=inactive) | timestamp

👉 Calculate total active hours per user per day

🔥 Real-Time Use Cases:
- User session tracking
- Website/app analytics
- Event-based systems
- Data pipeline transformations

💻 Tools Used:
- Oracle SQL

👉 Full solution explained step-by-step with query

📌 Subscribe for more:
SQL | PySpark | Databricks | Snowflake | Data Engineering

#OracleSQL #SQLInterview #DataEngineering #SQLQueries #WindowFunctions #ETL

Видео 👉 Oracle SQL Interview Question | Calculate Active Hours Per User Per Day (Real-Time Scenario) канала Rajasekar Data Engineer