Materialize/doc/user/layouts/partials/sql-grammar/list-agg.svg

<svg xmlns="http://www.w3.org/2000/svg" width="627" height="337">
   <polygon points="9 17 1 13 1 21"/>
   <polygon points="17 17 9 13 9 21"/>
   <rect x="31" y="3" width="74" height="32" rx="10"/>
   <rect x="29"
         y="1"
         width="74"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="39" y="21">list_agg</text>
   <rect x="125" y="3" width="26" height="32" rx="10"/>
   <rect x="123"
         y="1"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="133" y="21">(</text>
   <rect x="171" y="3" width="54" height="32"/>
   <rect x="169" y="1" width="54" height="32" class="nonterminal"/>
   <text class="nonterminal" x="179" y="21">value</text>
   <rect x="45" y="113" width="68" height="32" rx="10"/>
   <rect x="43"
         y="111"
         width="68"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="53" y="131">ORDER</text>
   <rect x="133" y="113" width="40" height="32" rx="10"/>
   <rect x="131"
         y="111"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="141" y="131">BY</text>
   <rect x="213" y="113" width="64" height="32"/>
   <rect x="211" y="111" width="64" height="32" class="nonterminal"/>
   <text class="nonterminal" x="221" y="131">col_ref</text>
   <rect x="317" y="145" width="50" height="32" rx="10"/>
   <rect x="315"
         y="143"
         width="50"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="325" y="163">ASC</text>
   <rect x="317" y="189" width="58" height="32" rx="10"/>
   <rect x="315"
         y="187"
         width="58"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="325" y="207">DESC</text>
   <rect x="435" y="145" width="106" height="32" rx="10"/>
   <rect x="433"
         y="143"
         width="106"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="443" y="163">NULLS LAST</text>
   <rect x="435" y="189" width="110" height="32" rx="10"/>
   <rect x="433"
         y="187"
         width="110"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="443" y="207">NULLS FIRST</text>
   <rect x="213" y="69" width="24" height="32" rx="10"/>
   <rect x="211"
         y="67"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="221" y="87">,</text>
   <rect x="147" y="271" width="26" height="32" rx="10"/>
   <rect x="145"
         y="269"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="155" y="289">)</text>
   <rect x="213" y="303" width="66" height="32" rx="10"/>
   <rect x="211"
         y="301"
         width="66"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="221" y="321">FILTER</text>
   <rect x="299" y="303" width="26" height="32" rx="10"/>
   <rect x="297"
         y="301"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="307" y="321">(</text>
   <rect x="345" y="303" width="70" height="32" rx="10"/>
   <rect x="343"
         y="301"
         width="70"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="353" y="321">WHERE</text>
   <rect x="435" y="303" width="98" height="32"/>
   <rect x="433" y="301" width="98" height="32" class="nonterminal"/>
   <text class="nonterminal" x="443" y="321">filter_clause</text>
   <rect x="553" y="303" width="26" height="32" rx="10"/>
   <rect x="551"
         y="301"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="561" y="321">)</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m74 0 h10 m0 0 h10 m26 0 h10 m0 0 h10 m54 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-244 110 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m68 0 h10 m0 0 h10 m40 0 h10 m20 0 h10 m64 0 h10 m20 0 h10 m0 0 h68 m-98 0 h20 m78 0 h20 m-118 0 q10 0 10 10 m98 0 q0 -10 10 -10 m-108 10 v12 m98 0 v-12 m-98 12 q0 10 10 10 m78 0 q10 0 10 -10 m-88 10 h10 m50 0 h10 m0 0 h8 m-88 -10 v20 m98 0 v-20 m-98 20 v24 m98 0 v-24 m-98 24 q0 10 10 10 m78 0 q10 0 10 -10 m-88 10 h10 m58 0 h10 m40 -76 h10 m0 0 h120 m-150 0 h20 m130 0 h20 m-170 0 q10 0 10 10 m150 0 q0 -10 10 -10 m-160 10 v12 m150 0 v-12 m-150 12 q0 10 10 10 m130 0 q10 0 10 -10 m-140 10 h10 m106 0 h10 m0 0 h4 m-140 -10 v20 m150 0 v-20 m-150 20 v24 m150 0 v-24 m-150 24 q0 10 10 10 m130 0 q10 0 10 -10 m-140 10 h10 m110 0 h10 m-372 -76 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m372 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-372 0 h10 m24 0 h10 m0 0 h328 m-560 44 h20 m560 0 h20 m-600 0 q10 0 10 10 m580 0 q0 -10 10 -10 m-590 10 v90 m580 0 v-90 m-580 90 q0 10 10 10 m560 0 q10 0 10 -10 m-570 10 h10 m0 0 h550 m22 -110 l2 0 m2 0 l2 0 m2 0 l2 0 m-502 158 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m26 0 h10 m20 0 h10 m0 0 h376 m-406 0 h20 m386 0 h20 m-426 0 q10 0 10 10 m406 0 q0 -10 10 -10 m-416 10 v12 m406 0 v-12 m-406 12 q0 10 10 10 m386 0 q10 0 10 -10 m-396 10 h10 m66 0 h10 m0 0 h10 m26 0 h10 m0 0 h10 m70 0 h10 m0 0 h10 m98 0 h10 m0 0 h10 m26 0 h10 m23 -32 h-3"/>
   <polygon points="617 285 625 281 625 289"/>
   <polygon points="617 285 609 281 609 289"/>
</svg>