SQL Interview Question | Find start date and end date of projects

SQL Interview Question | FAANG Interview Question | MAANG Interview Question | SQL Practice | SQL Preparation

[sass]

Awesome Explanation. Had 2 doubt. If you just write at the end
[ SELECT <col>
From <Table1>, <Table2>
where r1=r2. ]
-->>Would it be same To writing 'Join' and give same result?
-->>Also I first tried Start_Date != End_Date. The result was wrong. Why "!=" didnt give the same result as "Not In"? please help me understand