NVIDIA SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10163)

Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by NVIDIA and is called "Product Transaction Count".
Try this question on StrataScratch: platform.strat...
Find me on LinkedIn: / frederikmueller
Playlists:
• StrataScratch Coding Q...
• LeetCode Database Prob...
• LeetCode Easy Database...
• LeetCode Medium Databa...
• LeetCode Hard Database...

[@rahulpareek328]

I know you might be busy in your professional life but please don’t stop this series .. thanks man

[@frederikmuller]

Thank you both for being understanding and interested in seeing more. The plan is to keep the upload schedule at at least 1 video per week.

[@anirbansarkar6306]

Hi Frederik,
if possible can you zoom-in on the questions while reading questions and zoom in on solutions while solving,
actually this way we as audience will be getting better insights.
Your videos are really helpful and informative, I regularly watch them to keep myself relevant in sql.

[@frederikmuller]

Hey Anirbar, thank you, that’s awesome feedback. I already tried zooming in on the page in general but this will help even more.

[@anirbansarkar6306]

@@frederikmuller Thank you so much for acknowledging my feedback

[@saifullahhaidar391]

SELECT product_name, COUNT(DISTINCT transaction_id)
FROM excel_sql_inventory_data
JOIN excel_sql_transaction_data ON excel_sql_inventory_data.product_id = excel_sql_transaction_data.product_id
GROUP BY product_id, product_name
ORDER BY product_id ASC. Could you please tell me why this solution is not working.

[@ayeoh47]

Thanks for finally uploading. Can you please stop doing that. You didn’t upload for months. Thanks. Sorry but these videos are too good

[@frederikmuller]

You’re welcome, I didn’t know people were so eager on seeing new videos 😄 Did you already go through them all?

[@ayeoh47]

@@frederikmuller I went through them all like last year, landed 2 jobs because you taught me how to think. Then you bailed on me and I felt abandoned by my mentor.

[@frederikmuller]

@@ayeoh47 Congrats on your job offers, seems like the hard work paid off and the videos were helpful. I'm not on a contract, however, and will probably have more phases of inactivity.