SQL Interview Question 8/100 | First & Latest Payment per Merchant #dataanalytics

Q8. Write a query to get the first and latest payment date for each merchant.
Har merchant ke liye first aur latest payment date nikalni hai.

Is question mein hum dekhte hain kaise aggregation functions use karke data ko summarize karte hain.

Step by step logic:

• Hum data ko merchant level par group karte hain using GROUP BY
• MIN(payment_date) use karke sabse pehli payment date nikalte hain
• MAX(payment_date) use karke latest payment date nikalte hain

Key concept:

MIN hamesha smallest value deta hai → first date
MAX hamesha largest value deta hai → latest date

Yeh question simple lagta hai, lekin interviews mein frequently pucha jata hai to test your understanding of aggregation.

Follow Data Dino Edutech for daily SQL interview questions.
#sql #datascience #sqlinterviewquestions #interviewprep #dataanalyst

Видео SQL Interview Question 8/100 | First & Latest Payment per Merchant #dataanalytics канала Data Dino Edutech