Asked in Uber SQL Interview : Retrieve the 3rd Transaction per User #sql #viralvideo #viralshorts
CREATE TABLE transactions (
user_id INTEGER,
spend DECIMAL(10,2),
transaction_date TIMESTAMP
);
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 100.50, TO_TIMESTAMP('01/08/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 55.00, TO_TIMESTAMP('01/10/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (121, 36.00, TO_TIMESTAMP('01/18/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (145, 24.99, TO_TIMESTAMP('01/26/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 89.60, TO_TIMESTAMP('02/05/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Problem : https://datalemur.com/questions/sql-third-transaction
Видео Asked in Uber SQL Interview : Retrieve the 3rd Transaction per User #sql #viralvideo #viralshorts канала vikas_vooradi
user_id INTEGER,
spend DECIMAL(10,2),
transaction_date TIMESTAMP
);
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 100.50, TO_TIMESTAMP('01/08/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 55.00, TO_TIMESTAMP('01/10/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (121, 36.00, TO_TIMESTAMP('01/18/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (145, 24.99, TO_TIMESTAMP('01/26/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
INSERT INTO transactions (user_id, spend, transaction_date) VALUES (111, 89.60, TO_TIMESTAMP('02/05/2022 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Problem : https://datalemur.com/questions/sql-third-transaction
Видео Asked in Uber SQL Interview : Retrieve the 3rd Transaction per User #sql #viralvideo #viralshorts канала vikas_vooradi
uber sql interview question user's third transaction datalemur sql practice question sql interview prep sql tutorial sql intermediate sql advanced sql challenge sql query sql window functions sql order by sql subquery sql data analysis sql data science sql data engineering sql analytics sql uber uber data analyst interview uber data science interview sql transaction analysis sql user transaction sql third transaction sql transaction date
Комментарии отсутствуют
Информация о видео
12 мая 2025 г. 20:33:26
00:05:22
Другие видео канала
