Arungiri G

Arungiri G

  • 2.1k
  • 41
  • 2.1k

help on below output

Aug 25 2022 5:00 AM

create table Total_Points
(
id int primary key identity(1,1),
Code int Unique,
Points int
)
 
--insert into Total_Points values(1001,10)
--insert into Total_Points values(2001,20)
--insert into Total_Points values(3001,30)
--insert into Total_Points values(4001,40)
--insert into Total_Points values(5001,50)
 
--select * from Total_Points
--select * from Points_TRN
 
 
--create table Points_TRN
--(
--id int primary key identity(1,1),
--RefCode int ,
--EarnPoints int
--)
 
--insert into Points_TRN values(1001,1)
--insert into Points_TRN values(1001,2)
--insert into Points_TRN values(1001,3)
--insert into Points_TRN values(2001,2)
--insert into Points_TRN values(2001,2)
--insert into Points_TRN values(2001,2)
--insert into Points_TRN values(3001,7)
--insert into Points_TRN values(3001,5)
--insert into Points_TRN values(3001,4)
 
 
--Expected Output
-- id Code Totalpoint Earnpoint FinalPoint
 1   1001   10               6        4
 2   2001   20              6       14
 3   3001   30              16     14
 4   4001   40              0        0    
 5   5001   50              0        0


Answers (2)