influxdb - SQL Query to count entries in the column and get percentage

Question

student	have new books
alice	yes
bob	yes
candace	no
dalia	no
edd	no
frank	yes

question from:https://stackoverflow.com/questions/65843456/sql-query-to-count-entries-in-the-column-and-get-percentage

Answer 1

Use the conditional aggregation as follows:

select count(case when have_new_book = 'yes' then 1 end) / count(*)
 from your_Table