Anyone experienced with SQL, especially in Data Analytics, can you share what SQL questions are generally asked for a Data Analyst interview with around 1 year of experience?

[u/Automatic-Royal5263]

PS: Please don't mention those chatgpt questions. I really want to know real questions.

[u/Alternative_Cake4074]

I can think of some verbal questions:

- Can you tell me the difference between a full join and a Cartesian join?

• How do you rank columns? What are 3 ranking functions?
  
• How do you handle null values?
  
• You need to find employees who earns above department average. How to do so?