1DigitalStack

1. What is the difference between a Union and an Outer join, and can you provide the syntax for both using two simple tables?

2. What are the different types of joins in SQL?

3. Using only sorting and removing duplicates in Python, how would you solve the problem of product availability throughout the day for campaigns like Blinkit (campaignid_1) and Zepto (campaignid_2), given sample data, without applying any conditions or filters?