Skip to content
Advertisement

Combining several similar queries

How can I combine these three queries into one?

Advertisement

Answer

If I follow you correctly, you can use two levels of aggregation. The following query puts each bucket in a separate row:

Or you can get all three counts on the same row as follows:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement