To what logical plan are you referring in this section?

[ieugen]

I'm following along the tutorial after the presentation and it's not clear to me to which logical plan this piece is referring to.

Is this Exercise 3 from https://www.slideshare.net/julianhyde/apache-calcite-a-tutorial-given-at-boss-21 ?

Q1

SELECT o._o_custkey, COUNT(*)
FROM orders AS o
GROUP BY o.o_custkey

Q2

SELECT o.o_custkey, COUNT(*)
FROM orders AS o
WHERE o.o_totalprice > 220388.06
GROUP BY o.o_custkey

https://github.com/zabetak/calcite-tutorial/blob/31cce59c747e0b763a934109db6a6e7055f175ae/template/src/main/java/com/github/zabetak/calcite/tutorial/LuceneBuilderProcessor.java#L91