27. Tricky SQL Interview Problem Asked in Amazon | Best SQL Interview Series |

✅✅Geeks,

Here is the script:
create table purchase_table
(user_id int
,product_id int
,purchase_date date
);
SET DATEFORMAT dmy;
insert into purchase_table 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')
If you like this video please share and subscribe to my channel.

Full Playlist of ADF:
✅https://www.youtube.com/watch?v=9Ctq1_3Qs4o&list=PLxy0DxWEupiOnvh9Ujf-yS0IQzpokKjGf
Full Playlist of Databricks:
✅https://www.youtube.com/watch?v=uvrrN8aqZW0&list=PLxy0DxWEupiNjGSv1hzRFBXgSzV-bZu94
Full Playlist of PySpark Interview:
✅https://www.youtube.com/watch?v=Rp5LWT4or-o&list=PLxy0DxWEupiODTF_xM5Lw1ghc0XtLCUhC
Full Playlist of Python Interviews:
✅https://www.youtube.com/watch?v=F6HTQP3oDJA&list=PLxy0DxWEupiOkz6d22HQk3-A9rC-paq3y
Full Playlist of Snowflake SQL:
✅https://www.youtube.com/watch?v=no5VjmmPDGc&list=PLxy0DxWEupiP3oJralHpT8SjtdBY0BpYR
Full Playlist of Golang:
✅ https://www.youtube.com/watch?v=F3Wg2dYPh_U&list=PLxy0DxWEupiMckHLAJGQuHpYkKqYhqCZ5
Full Playlist of NumPY Library:
✅ https://www.youtube.com/watch?v=F3Wg2dYPh_U&list=PLxy0DxWEupiMckHLAJGQuHpYkKqYhqCZ5
Full Playlist of PTQT5:
✅ https://www.youtube.com/watch?v=NcATA...
Full Playlist of Pandas:
✅ https://www.youtube.com/watch?v=DKTcf6Wyuck&list=PLxy0DxWEupiP86ruA3QWoBG1Rb0b1BH4n

Linkedin: https://www.linkedin.com/in/sagar-prajapati-86073b155/
Instagram: https://www.instagram.com/prajaji/

#interviewquestions #sql #dataengineer

Видео 27. Tricky SQL Interview Problem Asked in Amazon | Best SQL Interview Series | канала GeekCoders