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

Pubblicato il: 08 ottobre 2024
sul canale di: Mohit Tyagi

372

------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')

In questa pagina del sito puoi guardare il video online Real Time SQL Interview Queries|| Find New Users & Repeat Users in SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Mohit Tyagi 08 ottobre 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 372 volte e gli è piaciuto 15 spettatori. Buona visione!

216