Generation

text to sql syntaxWed, 25 Jan 2023

select count working days of table A for each of the users in table b using google sheets

=QUERY({A!A3:B; B!A3:B; C!A3:B}, "select Col1, sum(Col2) where Col1 is not null group by Col1 label sum(Col2)''")

Want to kickstart your project?Use the new AI Studio to create your code