There are three tables.
(1) SalesPerson (SPID, Name, Post)
(2) SalesData (TID, SPID, Month, Year, Amount)
(3) SalesTarget (STID, SPID, Year, TargetAmt, SalesAmt)
Write a PL/SQL program to calculate SalesAmt of SalesTarget table.
Note: SPID, TID, STID auto number field.
STID, SPID, Year, TargetAmt fields are already populated.
Question asked by visitor bhumika d patel