SQL ERROR: Bad set function before FROM clause.


Execution ERROR: No command found!.

$VAR1 = undef;

##</code><code>##

    my $sth = $dbh->prepare("SELECT * FROM results WHERE 1=0");
    $sth->execute;
    my @cols = @{$sth->{NAME}};
    shift @cols;
    my $avgSQL =
      'SELECT '
      . join(', ', map { "avg($_) \n" } @cols )
      . ' FROM results';
    my $avgsHashRef = $dbh->selectrow_hashref($avgSQL);

##</code><code>##

Execution ERROR: Can't use AVG on a string! called from ./runsql3.sql at 24.

DBD::CSV::db selectrow_hashref failed: Attempt to fetch row from a Non-SELECT statement [for Statement "SELECT avg(ERWWCOMMUNITIESMemoryPagessec)
, avg(ERWWCOMMUNITIESNetworkInterfaceCompaqEthernetFastEthernetAdapterModuleBytesTotalPERsec)
, avg(ERWWCOMMUNITIESNetworkInterfaceMSTCPLoopbackinterfaceBytesTotalPERsec)
, avg(ERWWCOMMUNITIESNetworkInterfaceCompaqEthernetFastEthernetAdapterModuleCurrentBandwidth)
, avg(ERWWCOMMUNITIESNetworkInterfaceMSTCPLoopbackinterfaceCurrentBandwidth)
, avg(ERWWCOMMUNITIESPhysicalDisk0CPCTDiskTime)
, avg(ERWWCOMMUNITIESPhysicalDisk1DPCTDiskTime)
, avg(ERWWCOMMUNITIESPhysicalDiskTotalPCTDiskTime)
, avg(ERWWCOMMUNITIESPhysicalDiskTotalAvgDiskQueueLength)
, avg(ERWWCOMMUNITIESProcessorTotalPCTProcessorTime)
, avg(ERWWDC1MemoryPagesPERsec)
, avg(ERWWDC1NetworkInterfaceIntelPRO100NetworkConnectionBytesTotalPERsec)
, avg(ERWWDC1NetworkInterfaceMSTCPLoopbackinterfaceBytesTotalPERsec)
, avg(ERWWDC1NetworkInterfaceIntelPRO100NetworkConnectionCurrentBandwidth)
, avg(ERWWDC1NetworkInterfaceMSTCPLoopbackinterfaceCurrentBandwidth)
, avg(ERWWDC1PhysicalDisk0CPCTDiskTime)
, avg(ERWWDC1PhysicalDiskTotalPCTDiskTime)
, avg(ERWWDC1PhysicalDiskTotalAvgDiskQueueLength)
, avg(ERWWDC1ProcessorTotalPCTProcessorTime)
, avg(ERWWNABMemoryPagesPERsec)
, avg(ERWWNABNetworkInterfaceIntel8255xbasedIntegratedFastEthernetBytesTotalPERsec)
, avg(ERWWNABNetworkInterfaceMSTCPLoopbackinterfaceBytesTotalPERsec)
, avg(ERWWNABNetworkInterfaceIntel8255xbasedIntegratedFastEthernetCurrentBandwidth)
, avg(ERWWNABNetworkInterfaceMSTCPLoopbackinterfaceCurrentBandwidth)
, avg(ERWWNABPhysicalDisk0CPCTDiskTime)
, avg(ERWWNABPhysicalDiskTotalPCTDiskTime)
, avg(ERWWNABPhysicalDiskTotalAvgDiskQueueLength)
, avg(ERWWNABProcessorTotalPCTProcessorTime)
, avg(ERWWSEARCHMemoryPagesPERsec)
, avg(ERWWSEARCHNetworkInterfaceBroadcomNetXtremeGigabitEthernetDriverBytesTotalPERsec)
, avg(ERWWSEARCHNetworkInterfaceIntelPRO100NetworkConnectionBytesTotalPERsec)
, avg(ERWWSEARCHNetworkInterfaceMSTCPLoopbackinterfaceBytesTotalPERsec)
, avg(ERWWSEARCHNetworkInterfaceBroadcomNetXtremeGigabitEthernetDriverCurrentBandwidth)
, avg(ERWWSEARCHNetworkInterfaceIntelPRO100NetworkConnectionCurrentBandwidth)
, avg(ERWWSEARCHNetworkInterfaceMSTCPLoopbackinterfaceCurrentBandwidth)
, avg(ERWWSEARCHPhysicalDisk0CDPCTDiskTime)
, avg(ERWWSEARCHPhysicalDiskTotalPCTDiskTime)
, avg(ERWWSEARCHPhysicalDiskTotalAvgDiskQueueLength)
, avg(ERWWSEARCHProcessorTotalPCTProcessorTime)
, avg(ERWWSQLWEBMemoryPagesPERsec)
, avg(ERWWSQLWEBNetworkInterfaceBroadcomNetXtremeGigabitEthernetDriverBytesTotalPERsec)
, avg(ERWWSQLWEBNetworkInterfaceMSTCPLoopbackinterfaceBytesTotalPERsec)
, avg(ERWWSQLWEBNetworkInterfaceBroadcomNetXtremeGigabitEthernetDriverCurrentBandwidth)
, avg(ERWWSQLWEBNetworkInterfaceMSTCPLoopbackinterfaceCurrentBandwidth)
, avg(ERWWSQLWEBPhysicalDisk0CDPCTDiskTime)
, avg(ERWWSQLWEBPhysicalDiskTotalPCTDiskTime)
, avg(ERWWSQLWEBPhysicalDiskTotalAvgDiskQueueLength)
, avg(ERWWSQLWEBProcessorTotalPCTProcessorTime)
 FROM results"] at ./runsql3.sql line 24.
$VAR1 = undef;