Real Time SQL Interview Queries|| Find New Users & Repeat Users in SQL

------create table-----
create table users_visit(User_Id varchar(50), Name varchar(50),Orderdate date)

------insert data------
insert into users_visit values('L-101','Ram','10-01-2024')
insert into users_visit values('L-102','Aman','10-01-2024')
insert into users_visit values('L-103','Shyam','10-01-2024')
insert into users_visit values('L-104','Rohan','11-01-2024')
insert into users_visit values('L-102','Aman','11-01-2024')
insert into users_visit values('L-106','Chand','11-01-2024')
insert into users_visit values('L-103','Rohan','11-01-2024')
insert into users_visit values('L-108','Wazir','11-01-2024')
insert into users_visit values('L-109','Queen','12-01-2024')
insert into users_visit values('L-106','Chand','12-01-2024')
insert into users_visit values('L-108','Wazir','12-01-2024')
insert into users_visit values('L-104','Amit','12-01-2024')
insert into users_visit values('L-110','Amit','12-01-2024')
insert into users_visit values('L-111','Sumit','12-01-2024')
insert into users_visit values('L-112','Rohit','13-01-2024')
insert into users_visit values('L-113','Shohit','13-01-2024')
insert into users_visit values('L-109','Mohit','13-01-2024')
insert into users_visit values('L-110','Mohit','13-01-2024')
insert into users_visit values('L-111','Raju','13-01-2024')
insert into users_visit values('L-115','Raju','13-01-2024')