In order to leverage the power of data correlation within Nessus, a cybersecurity analyst needs to write an SQL statement that will provide how long a vulnerability has been present on the network. Given the following output table:
Which of the following SQL statements would provide the resulted output needed for this correlation?
A. SELECT Port, ScanDate, IP, PlugIn FROM MyResults WHERE PluginID=’1000′
B. SELECT ScanDate, IP, Port, PlugIn FROM MyResults WHERE PluginID=’1000′
C. SELECT IP, PORT, PlugIn, ScanDate FROM MyResults SET PluginID=’1000′
D. SELECT ScanDate, IP, Port, PlugIn SET MyResults WHERE PluginID=’1000′