PG&E Rebate report for K1000
Our company qualifies for a $15 per computer rebate from our electricity provider, PG&E, for using K1000 power management. In order to apply for the rebate we must submit a report which lists each PG&E account number and the number of computers that are in each account. We have created labels for each site with the naming convention of PGE_<site_name>_<PGE-account-number> (example: PGE_PA_56676543). There are around 20 labels.
We need to create a report that will list all of the labels that start with PGE and then list the total number of computers that are in those labels to the right of each label name. Any suggestions on how to create a SQL report to do this task would be greatly appreciated.