WNP@HWPROD1> sta HRA_by_location-1.sql HRA_STATUS COUNT(M.HRA_STATUS) -------------------- ------------------- 0 COMPLETE 4909 LOCATION COUNT_HRA_COMPLETED ------------------------------ ------------------- Arizona 1 Arkansas 1 Branchburg 23 Bushy Park 20 California 1 Illinois 2 Indiana 1 Minnesota 1 New York (Studio) 4 Ohio 10 Saddle Brook 21 Teterboro 111 Texas 1 Wisconsin 2 14 rows selected. LOCATION COUNT_TOTAL_USERS ------------------------------ ----------------- Arizona 1 Arkansas 2 Branchburg 131 Bushy Park 50 California 1 Florida 1 Georgia 1 Illinois 2 Indiana 1 Iowa 1 Minnesota 2 New York (Studio) 29 No Data 17 Ohio 59 Saddle Brook 32 Teterboro 330 Texas 1 Washington 1 Wisconsin 8 1 20 rows selected. WNP@HWPROD1> spool off