qSQL
Grouping & Aggregation
Practice questions on the by clause, fby for group-level filtering without collapsing rows, and xbar for time-bucketed aggregation.
Practice Questions
Test your understanding with 9 hands-on questions
01Count Rows by Group02xbar: Count Rows in Time Buckets03fby: Find the Highest Price for Each Symbol Using fby04fby: Select First,Last and Second Last Rows by Group05Find the Symbol With the Most Appearances06Count Rows per Symbol with a Filter07Select the Maximum-Price Row per Symbol08Select the Last N Rows per Symbol09Count Rows per 15-Minute Bucket, per Symbol