Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data analyst needs to identify which customers have placed an order in the past year and which have not, using a single statement that joins a unique customers table and an orders table.
Which type of join should be used?
A
Left Semi Join
B
Left Join
C
Middle Join
D
Left Anti Join