hive中的with用法 旧城等待, 2022-05-24 01:09 274阅读 0赞 hive 可以通过with查询来提高查询性能,因为先通过with语法将数据查询到内存,然后后面其它查询可以直接使用 <table style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:770px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:normal;width:1195.2px;word-spacing:0px;"> <tbody> <tr style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;width:auto;"> <td style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-size:14px;height:770px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:15px;padding-right:0px;padding-top:0px;vertical-align:baseline;width:1180.2px;"> <div title="Hint: double-click to select code" style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:740px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:15px;padding-bottom:15px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre-wrap;width:1180.2px;"> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">( </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">src </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">)</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">*</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1;</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- from style</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">(</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">src </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">)</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">*;</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"> </code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- chaining CTEs</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">( </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q2 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">),</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q2 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">( </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">src </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">)</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">(</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1) a;</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"> </code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- union example</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">(</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">src </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">),</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q2 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">(</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">src s2 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">= </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'4'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">)</code> </div> <br> <div style="background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;height:20px;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;vertical-align:baseline;white-space:nowrap;width:1166.2px;"> <div> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q1 </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">union</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(128,128,128);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(128,128,128);border-left-style:none;border-left-width:0px;border-right-color:rgb(128,128,128);border-right-style:none;border-right-width:0px;border-top-color:rgb(128,128,128);border-top-style:none;border-top-width:0px;color:rgb(128,128,128);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">all</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">* </code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">q2;</code> </div> <div> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><br></code> </div> <div> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"></code> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- insert example</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">create</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">table</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">s1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(128,128,128);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(128,128,128);border-left-style:none;border-left-width:0px;border-right-color:rgb(128,128,128);border-right-style:none;border-right-width:0px;border-top-color:rgb(128,128,128);border-top-style:none;border-top-width:0px;color:rgb(128,128,128);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">like</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">( </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">, value </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">= </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">)</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">insert</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">overwrite </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">table</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">s1</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">*;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- ctas example</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">create</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">table</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">s2 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">( </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">= </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'4'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">)</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">* </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- view example</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">create</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">view</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">v1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">( </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">= </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">)</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">* </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">* </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">v1;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;"> </span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><span style="color:#333333;"></span><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,130,0);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,130,0);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,130,0);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,130,0);border-top-style:none;border-top-width:0px;color:rgb(0,130,0);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">-- view example, name collision</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">create</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">view</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">v1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">( </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">= </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'5'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">)</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">* </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1;</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">with</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">q1 </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">as</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">( </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">src </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">where</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">key</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">= </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,0,255);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,0,255);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,0,255);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,0,255);border-top-style:none;border-top-width:0px;color:rgb(0,0,255);float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">'4'</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">)</span></code> </div> <span style="float:none;background-color:transparent;color:rgb(51,51,51);font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;letter-spacing:normal;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;"><br></span> <div style="background-color:transparent;background-image:none;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;color:rgb(51,51,51);float:none;font-family:Consolas;font-size:14px;font-style:normal;font-variant:normal;font-weight:400;height:20px;letter-spacing:normal;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:14px;padding-top:0px;text-align:left;text-decoration:none;text-indent:0px;text-transform:none;vertical-align:baseline;white-space:nowrap;width:1166.2px;word-spacing:0px;"> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">select</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">* </span></code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(0,102,153);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(0,102,153);border-left-style:none;border-left-width:0px;border-right-color:rgb(0,102,153);border-right-style:none;border-right-width:0px;border-top-color:rgb(0,102,153);border-top-style:none;border-top-width:0px;color:rgb(0,102,153);float:none;font-family:Consolas;font-size:14px;font-weight:700;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;">from</code> <code style="background-attachment:scroll;background-color:transparent;background-image:none;background-repeat:repeat;border-bottom-color:rgb(51,51,51);border-bottom-style:none;border-bottom-width:0px;border-left-color:rgb(51,51,51);border-left-style:none;border-left-width:0px;border-right-color:rgb(51,51,51);border-right-style:none;border-right-width:0px;border-top-color:rgb(51,51,51);border-top-style:none;border-top-width:0px;float:none;font-family:Consolas;font-size:14px;height:auto;margin-bottom:0px;margin-left:0px;margin-right:0px;margin-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;vertical-align:baseline;white-space:pre;width:auto;"><span style="color:#333333;">v1;</span></code> </div> </div> </div> </div></td> </tr> </tbody> </table>
还没有评论,来说两句吧...