Real Time SQL Interview Queries|| Technical Round || Case Statement

Adding DDL & DML commands:
create table years_sum(
Order_ID int,Customer_Name varchar(50),Order_Date date,Amount int
)
insert into years_sum values(1001,'A','2020-01-16',200)
insert into years_sum values(1002,'B','12-02-2020',140)
insert into years_sum values(1003,'C','14-03-2020',150)
insert into years_sum values(1004,'D','20-05-2020',200)
insert into years_sum values(1005,'A','17-06-2021',180)
insert into years_sum values(1006,'B','23-07-2021',190)
insert into years_sum values(1007,'C','26-08-2021',210)
insert into years_sum values(1008,'D','14-09-2021',250)
insert into years_sum values(1009,'A','14-10-2022',220)
insert into years_sum values(1010,'B','15-01-2022',230)
insert into years_sum values(1011,'C','16-02-2022',240)
insert into years_sum values(1012,'D','18-03-2022',260)
-------------
create table sub_sum(
S_ID int,Subject varchar(50),Marks int)
insert into sub_sum values(1001,'English',90)
insert into sub_sum values(1001,'Math',70)
insert into sub_sum values(1001,'Science',80)
insert into sub_sum values(1001,'Sports',60)
insert into sub_sum values(1002,'English',60)
insert into sub_sum values(1002,'Math',70)
insert into sub_sum values(1002,'Science',80)
insert into sub_sum values(1002,'Sports',70)
insert into sub_sum values(1003,'English',60)
insert into sub_sum values(1003,'Math',50)
insert into sub_sum values(1003,'Science',60)
insert into sub_sum values(1003,'Sports',70)

[@KomalTyagi-p4o]

Nice 👌

[@thearyavartmedia]

Keep uploading these questions. Very helpful🙏

[@MubarakAli-qs9qq]

The way u handle question is anazing

[@mohittyagi9141]

@@MubarakAli-qs9qq thank you for supporting

[@sampathkumarreddy4354]

Kindly write the complete question on top of tables .