Tricky SQL Interview Problem Asked in Amazon скачать в хорошем качестве

Tricky SQL Interview Problem Asked in Amazon

In this video we are going to discuss a SQL interview problem asked in Amazon for a Business Intelligence Engineer Position. Here is the script: create table purchase_history (userid int ,productid int ,purchasedate date ); SET DATEFORMAT dmy; insert into purchase_history values (1,1,'23-01-2012') ,(1,2,'23-01-2012') ,(1,3,'25-01-2012') ,(2,1,'23-01-2012') ,(2,2,'23-01-2012') ,(2,2,'25-01-2012') ,(2,4,'25-01-2012') ,(3,4,'23-01-2012') ,(3,1,'23-01-2012') ,(4,1,'23-01-2012') ,(4,2,'25-01-2012') ; Zero to hero(Advance) SQL Aggregation:    • All About SQL Aggregations | SQL Advance |...   Most Asked Join Based Interview Question:    • Most Asked SQL JOIN based Interview Questi...   Solving 4 Trick SQL problems:    • Solving 4 Tricky SQL Problems   Data Analyst Spotify Case Study:    • Data Analyst Spotify Case Study | SQL Inte...   Top 10 SQL interview Questions:    • Top 10 SQL interview Questions and Answers...   Interview Question based on FULL OUTER JOIN:    • SQL Interview Question Based on Full Outer...   Playlist to master SQL :    • Complex SQL Questions for Interview Prepar...   Rank, Dense_Rank and Row_Number:    • RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...   #sql #dataengineer