SQL Interview Questions Part 58 | WALMART Interview Question & Answer Part - 3 🔥🔥
SQL Interview Questions Part 58 | WALMART Interview Question & Answer Part - 3
This question has been asked in WALMART interview. This question will be helpful in cracking any SQL interview
Problem Statement : Assume you are given the below table on transactions from users. Based on their latest transaction date, write a query to obtain the number of users who made a purchase and the total number of products bought for each transaction date.
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
*Instagram :
/ itjunction4all
*Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
Table and Insert SQL Script :
-------------------------------------------------------------------------
Create Table user_transactions(
product_id integer,
users_id integer,
spend decimal,
transaction_date Datetime
)
Drop Table user_transactions;
INSERT INTO user_transactions Values(3673, 123, 68.90 ,'07/08/2022 10:00:00')
INSERT INTO user_transactions Values(9623, 123, 274.10 ,'07/08/2022 10:00:00')
INSERT INTO user_transactions Values(1467, 115, 19.90 ,'07/08/2022 10:00:00')
INSERT INTO user_transactions Values(2513, 159, 25.00 ,'07/08/2022 10:00:00')
INSERT INTO user_transactions Values(1452, 159, 74.50 ,'07/10/2022 10:00:00')
INSERT INTO user_transactions Values(1452, 123, 74.50 ,'07/10/2022 10:00:00')
INSERT INTO user_transactions Values(9765, 123, 100.15 ,'07/11/2022 10:00:00')
INSERT INTO user_transactions Values(6536, 115, 57.00 ,'07/12/2022 10:00:00')
INSERT INTO user_transactions Values(7384, 159, 15.50 ,'07/12/2022 10:00:00')
INSERT INTO user_transactions Values(1247, 159, 23.40 ,'07/12/2022 10:00:00')
#WalmartSQLQuestions #WALMARTInterview #WALMARTSQLInterview #FAANG #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #MAANG #sqlInterviewQuestionsForTesting