Amazon SQL Interview Questions: How to Solve Like a Pro | Advanced SQL Interview Question

[@parthchauhan9305]

This is my solution: - select c.name from Orders o join customer c on o.customer_id = c.id join product p on o.product_id = p.id group by customer_id having SUM(case when p.name = 'Samsung' then 1 when p.name = 'iPhone' then 2 else 0 end) = 3 Just a little tweak in the case when statement, everything else is same.

[@TwiceMind]

Sir will you help how to apply or update on how to prepare for Data Analytics especially with SQL and the project behind it. as I am a career gap graduate... don't know how to comeback in life

[@Thedata.techclub]

Re-entering the workforce after a career gap can seem challenging, but with a focused approach, especially in high-demand fields like Data Analytics, you can build a successful path forward. Learn SQL basics to advanced topics (e.g., JOIN, window functions) and explore tools like Python, Excel, and Tableau. Use platforms like Coursera, Kaggle, and LeetCode for practice and certifications. Analyze public datasets, create dashboards, and showcase work on GitHub. Connect with professionals, join webinars, and target entry-level roles (e.g., Data Analyst, SQL Developer). You’re not alone in this journey-many have successfully transitioned into Data Analytics after a gap. Stay focused, consistent, and confident. Let me know if you’d like help refining your resume, LinkedIn profile, or portfolio!