Hi all, I have a SQL interview with Walmart for a products analytic position. Can you please give me some tips of how to prepare for it? I’m good with very basic SQL Functions; JOINS, CASE, WHERE etc. What other things should I focus on?! PLEASE HELP!!!!!!! #e-commerce
Windows, self joins with alias, datediff, where datetime = functions, doing everything with left join and leave inner, outer, other joins at home.
Focus on window functions, CTEs, Self Joins, date functions
Thanks!
+1 to this. Op are you using LC or BTI to practice these sql concepts?