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

calcite-tutorial/template/src/main/java/com/github/zabetak/calcite/tutorial/LuceneBuilderProcessor.java

Line 91 in 31cce59

// TODO 2. Use the RelBuilder to create directly a logical plan for execution