As part of a custom development, a developer creates a Lightning Component to show how a particular opportunity progresses over time. The component must display the date stamp when any of the following fields change:
• Amount Probability, Stage, or Close Date
What is the most efficient way to Query such information?
A. [Select Amount, CloseDate, StageName, Probability FROM OpportunityHistory WHERE Opportunityld = :oppId];
B. [Select Newvalue, Oldvalue From OpportunityField_History Where Oppportunity = oppid AND Field IN
C. [Select NewValue, Oldvalue FROM Opportunity FieldHistory WHERE Opportunityld = :oppId AND Field IN
D. (‘StageName’, Probability’,Amount /CloseDate’)];
E. [Select Amount CloseDate. StageName, Probability FROM Opportunity_History WHERE Opportunityld – :oppId];