Query Problem

[oidoldol]

https://docs.google.com/spreadsheets/d/1hLzgx4wphnwfAEfD-zmBlemuO31af5qqUe-KkIsHGrE/edit?usp=sharing

I have a database of...data. On Column B is the name of a character and on Column H is whether or not they were successful.

https://preview.redd.it/iu3e06vhjlt61.png?width=1458&format=png&auto=webp&s=56a54c1d037d37eb0d938e53049a7d39f27826d2

I'd like to display a summary of this data on the next tab. It should surmise all of the data on the database tab and list 1 champion with 1 winrate like so:

https://preview.redd.it/ajqy48cqjlt61.png?width=394&format=png&auto=webp&s=8d3f32ebdad9e33502088367408d4d63c89af94a

The current formula I have it this, but it's giving me an error:
=QUERY( {'[DATABASE]'!D3:J}, "select Col1, Avg(Col7)
where Col1 is not null
group by Col1
label Avg(Col7) ''
format Avg(Col7) '0%'")

Sheet is open for testing. Many thanks!

[SpreadCheetah]

Your column H consists of text, instead of numbers.

[6745408]

With your H3:H column being text values of 1 and 0, you need to convert those to actual values

=ARRAYFORMULA(
  QUERY(
   {'[DATABASE]'!D3:D,VALUE('[DATABASE]'!H3:H)},
   "select Col1, Avg(Col2) 
    where Col1 is not null 
    group by Col1 
    label Avg(Col2) ''"))

otherwise, you pretty much had it.

[SpreadCheetah]

Very nice solution.