Depends. Cops from some dept's score 91% hits (on the PERP) in actual shootings... in other places (oddly enough, often those where citizens are mostly disarmed) some departments score as low as 17% in actual shootings.
For SC CWP, at the time I did it, you had to put over half your rounds into the K-zone of a silouette at up to 15 or 20 yards (I forget which). There were six other people taking the course that day when I did it, the only one that had any problem doing this was an older lady who had never shot much. The instructor went over some things with her (grip, trigger squeeze, sight picture, etc) and she qual'd on her second try.
I put every round through the K-zone, and so did the guy next to me. Of course, I'd been shooting since I was knee-high, and when I was a cop I routinely out-shot the Department instructor at the range. Not bragging, just fact. In my estimation the shooters on the line in my CCW class were mostly on-par with the cops I shot with when I was doing the LE thing.
Around here, it is just kind of expected that you know how to shoot already if you show up and apply for an LE job. If you don't already shoot fairly well, you get some funny and/or exasperated looks.
I've never lived in NYC but I have friends who have, some of whom were involved in LE or Military activities in or around the city. They've told me that it is astonishing how very very few NY'ers know how to DO anything.... swim, drive, operate "heavy" machinery like a backhoe, fix anything mechanical... or shoot any kind of firearm. According to some of my sources most NYPD recruits have never fired a handgun before joining and many have never fired ANY actual firearm. This kinda explains a lot, in terms of NYC's poor record on cop shoots.
Last I heard, they were also using those damn 9-pound "NY triggers" on their 9mm Glocks, which is a good way to ruin even a good shooter's aim. They did this in response to an excessive number of negligent discharges resulting in injury... but the solution to that is good training not heavy-ass triggers.
Studies have been done about what sort of person does well in a shootout, hitting their man and putting him down without hitting bystanders. The conclusion was that the best shooters in real shootouts have some or most of the following traits:
1. Was a shooter before joining LE.
2. Experienced Hunter.
3. Engaged in competitive target shooting.
4. Engaged in precision shooting competition.
5. Handloader/Reloader (shows a depth of involvement in shooting activities)
6. Exhibits skill-acquisition behavior in other areas (ie possesses other skills like driving, swimming, martial arts/boxing/wrestling, biking, etc)
7. Exhibits ability to think on his feet and/or function under stress.
8. Military background, especially combat arms.
These were some of the characteristics some departments looked for in special-operation units that were likely to engage in shoot outs with violent perps... someone with 3 or 4 or more of the above traits typically did well in such engagements.
It's hard to be sure who will keep their stuff wired tight in a fight until it actually happens... but statistically CCW'ers shoot far fewer bystanders than cops per-capita so it isn't the CCW'ers we need to worry about....