SQL Interview Questions | PYTD Sales | Infosys

💼 SQL Interview Questions | PYTD Sales | Infosys Scenario

In this video, we solve a real-world SQL interview question based on PYTD (Previous Year To Date) Sales, commonly asked in companies like Infosys.

📊 Problem Statement:
Calculate PYTD sales by comparing current year sales with the same date range in the previous year.

🔍 What you’ll learn:

What is PYTD (Previous Year To Date)
Difference between YTD vs PYTD
How to filter same date range last year
Writing SQL for PYTD calculation
Handling real-time interview scenarios

📅 Example:

YTD → Jan 1, 2026 to May 3, 2026
PYTD → Jan 1, 2025 to May 3, 2025

Видео SQL Interview Questions | PYTD Sales | Infosys канала Prabhakar