amazon interview question and answer
finding user purchases
Create Table Statement:
====================
create table amazon_interview (
user_id int,
item varchar(50),
created_at date,
revenue bigint
);
insert into amazon_interview(user_id , item , created_at, revenue)
values(100, 'bread', '07-03-2020', 410),(100, 'banana' ,'13-03-2020' ,175),
(100, 'banana','29-03-2020', 599),
(101, 'milk', '01-03-2020', 449),
(101, 'milk', '26-03-2020', 740),
(114, 'banana', '10-03-2020', 200),
(114, 'biscuit', '16-03-2020', 300);
Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy
Let's connect on LinkedIn : https://www.linkedin.com/in/dhirajgupta141/
top interview question and answer in pyspark :
https://youtube.com/playlist?list=PLqGLh1jt697yISVOi54qPLRKX1ExluhY2&si=BK_7MkOr0SnS_p6s
PySpark Installation and Setup : https://youtu.be/jO9wZGEsPRo?si=WVktJl4eh0mN3P9X
DSA In Python Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697wQTamFvXx_Odlm-Wg3zbxq&si=CAiVdcY4A7CEOKlO
PySpark Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697zXpQy8WyyDr194qoCLNg_0&si=-JG6S1LyZzjDZyPB
Pandas Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697yabH8-hRdV8Y5nzIEHDo29&si=1bwfHNeKLvcUFFXX
SQL Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697xtgiGwGUTFpOctT82ANdJZ&si=fsF6PkJiStf9_Dh-
#amazon #deloitte #zs #fang #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion
