Advanced SQL Query - 2 | Interview Question | Nested GROUP BY
Script for creating Table:
drop table new_cust;
create table new_cust (
joining_date date,
customer_id int
);
insert into new_cust
values(cast('2019-10-02' as date),3),(cast('2019-07-01' as date),7),(cast('2020-01-01' as date),3),(cast('2020-02-23' as date),19)
,(cast('2022-10-10' as date),3),(cast('2022-12-15' as date),3),(cast('2023-02-28' as date),12) ,(cast('2023-08-08' as date),19);
select * from new_cust
On this page of the site you can watch the video online Advanced SQL Query - 2 | Interview Question | Nested GROUP BY with a duration of hours minute second in good quality, which was uploaded by the user Shreyas 06 June 2023, share the link with friends and acquaintances, this video has already been watched 306 times on youtube and it was liked by 13 viewers. Enjoy your viewing!
