Question: PLEASE SOLVE IT CORRECTLY WITH OUTPUT SCREENSHOT OTHERWISE WILL DOWNVOTE OR IF YOU SOLVE PROPERYL WILL UPVOTE ALSO 1. Mr. Arun Kumar S/o Mr. Suraj

PLEASE SOLVE IT CORRECTLY WITH OUTPUT SCREENSHOT OTHERWISE WILL DOWNVOTE OR IF YOU SOLVE PROPERYL WILL UPVOTE ALSOPLEASE SOLVE IT CORRECTLY WITH OUTPUT SCREENSHOT OTHERWISE WILL DOWNVOTE OR IF

1. Mr. Arun Kumar S/o Mr. Suraj Kumar has purchased 10 acres of land in 20000000. 2. Mr. Amit Kumar S/o Mr. Arun kumar has purchased 15 acres of land in 25000000. 3. Mr. Ram Kumar S/o Mr. Arun kumar and Mr. Amit Kumar S/o Mr. Arun kumar have purchased 20 acres of land in 30000000. 4. Mrs. Anjali Devi W/o Mr. Amit Kumar has purchased 12 acres of land in 15000000. 5. Mr. Manish Kumar S/o Mrs. Anjali Devi has purchased 17 acres of land in 17000000. 6. Mr. Manish Kumar S/o Mr. Amit Kumar and Ms. Priya D/o Mrs. Anjali Devi have purchased 20 acres of land in 19000000. Parse the above statements and store it in any data structure. Program should work with any number of statements and any name, land or amount. Your program should take the following input and calculate accordingly: Select * from LR where name = 'Arun Kumar' Select Sum(Land) from LR where name = 'Amit Kumar' Select Sum(Amount) from LR where name = 'Anjali Devi' Select * from LR where FamilyTree = 'Amit Kumar' Select Sum(Land) from LR where FamilyTree = Suraj Kumar' Select Sum(Amount) from LR where FamilyTree = 'Arun Kumar

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!