GOOGLE Interview Question | SQL Intermediate Question 8
Вставка
- Опубліковано 14 жов 2024
- QUESTION - COUNT UNIQUE USER EACH DAYY
DDL Comands :
-- Create the UserActivity table
drop table UserActivity
CREATE TABLE UserActivity (
ActivityDate DATE,
User_id INT
);
-- Insert values into the UserActivity table
INSERT INTO UserActivity (ActivityDate, User_id)
VALUES
('2023-01-01', 1),
('2023-01-01', 2),
('2023-01-02', 1),
('2023-01-02', 3),
('2023-01-02', 2),
('2023-01-03', 1),
('2023-01-03', 3);
select * from UserActivity
#google #facebook #amazon #googleinterview #dataanalytics #sql #sqldeveloper #dataengineering #bigdata #ai #ml