I hope the subject name I selected helps explain a bit what I'd like to accomplish.
I have a single-row table where each column marks a different sample size totals needed based on that time bracket.
I have a second table where those columns are represented by 1 or 0, 1 being a valid sample/row, and 0 means it's not a good sample. Essentially, I got the first table by adding all of the 1s in the second.
What I'd like to do, based on the total given in that first table, is to select that number of records in my second table. So, the result would only keep 95 records from "Sum '11-'15", and 101 records from "Sum '16-'20". Ideally at random, as opposed to just first N records.
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |