I have a data extension which has a boolean field
option. I have another data extension which has 2 fields
percent. I'd like to write a query that gives me a percent value of the number of true and false values in the original table. The column types in the destination table don't really matter and could be text, I just need to get the values.
The output would look like this:
| option | percent | |--------|---------| | true | 35 | | false | 65 |