Real Time SQL Interview Queries|| Technical Round ||
Вставка
- Опубліковано 19 вер 2024
- ----create table--------
create table Shipment_Month(
Shipping_ID int,
Subject_ID int,
Weight_kg int,
Shipment_Dt date)
-------Insert data------
insert into Shipment_Month values(101,1,10,'2021-08-20')
insert into Shipment_Month values(101,2,12,'2021-08-21')
insert into Shipment_Month values(101,3,8,'2021-08-28')
insert into Shipment_Month values(101,4,7,'2021-08-29')
insert into Shipment_Month values(102,1,10,'2021-09-01')
insert into Shipment_Month values(102,2,12,'2021-09-10')
insert into Shipment_Month values(102,3,10,'2021-09-12')
insert into Shipment_Month values(103,1,6,'2021-09-15')
insert into Shipment_Month values(103,2,7,'2021-09-27')
insert into Shipment_Month values(104,1,8,'2021-10-02')
insert into Shipment_Month values(104,2,10,'2021-10-10')
insert into Shipment_Month values(104,3,11,'2021-10-20')
insert into Shipment_Month values(105,1,10,'2022-01-01')
insert into Shipment_Month values(105,2,12,'2022-01-10')
insert into Shipment_Month values(105,3,9,'2022-01-20')
Nice 👌
select year(Shipment_Dt) as year, monthname(Shipment_Dt) as month, count(*) as total_orders from Shipment_Month
group by year, month;