docs/src/two-kinds-of-sql-query-builders/males-among-100-oldest-patients.drawio.svg

<?xml version="1.0" encoding="UTF-8"?>
<!-- Do not edit this file with editors other than diagrams.net -->
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="701px" height="441px" viewBox="-0.5 -0.5 701 441" content="&lt;mxfile host=&quot;Electron&quot; modified=&quot;2022-08-29T13:25:26.228Z&quot; agent=&quot;5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/20.2.3 Chrome/102.0.5005.167 Electron/19.0.11 Safari/537.36&quot; etag=&quot;bgPdVB4w5QW24XK1H92G&quot; version=&quot;20.2.3&quot; type=&quot;device&quot;&gt;&lt;diagram id=&quot;YkCwad8bBgtQqS6dPUib&quot; name=&quot;Page-1&quot;&gt;7VrbcuI4EP0aHtnyDWMeA4EkM8kyVewWO3mhhC0bD8LyyuLi+fqVsYxjWzgs40uYSvKA1ZKlVnefo1ZDRx1tDg8E+KsXbEHUUSTr0FHvO4oiS6rBPiJJGEt0XYsFDnEtPigVzNyfMHmTS7euBYPMQIoxoq6fFZrY86BJMzJACN5nh9kYZVf1gQMLgpkJUFE6dy264lJdktKOR+g6K770IOnYgGQwFwQrYOH9G5E67qgjgjGNnzaHEUSR8RK7xO9NzvQuH0f98fB1azrocfA8NoZf/953ubY7gLZc/yEw1w7BW8/iWtAw2RrC5hpGs8kddZjshkCPXr28Uli+sOhRleOqElt1v3IpnPnAjHr3LIKYbEU3iCtluwiNMMKEtS1ogy1iug0DSvAaJnIPe1Cof6mBIKHw8MbDfJMPEG8gJSEbcsjGIQ/fxJn7NBb6icdXb8JA07gQ8PhzTjOnRmUP3K5iGxe9ee8Ch4BNta7862n5sg7mxuL7gZKXkTx/kAddeVBYBFoMGbzJrc5i2o+aNoKHuwhtTJb1MCZ0hR3sAfSMsc81/AEpDTnWwZbirNeL+nNDBHhLTFiidOKdSNNS5xKIAHV3WYyLXMVf/YZdpksaFFo2KgrepoA4kPK3cg4/qXFRDJTuMwM0PQaHD7yM2/R/txHDDG3s0W5wtPkdGyDr/iHtZE8O/zzOskwEM4giVuVipuwyP5TJ4jVzM5C8xE0EPiQB9hZsh+kUbjr6LGHI1xLG2YC6nAZyDlf1Ig8oQh6ogAbEIdBvDZ/MiiT8J3r/j17S/M6nOzbuD5lWyFu/gGueRMSw+oAEcIqHpgjAaIoAnt2NWzH+5Qgot4p8xWgQ+ZM/X5+maxhOvd30h7RbhJ606KqlwE/xPE6l7WFeREAX8YCh3SF/aWo2mW8Wu2clMKZmVy/SgNBEctUscKnDFtL+UX19ehjP9u7E+fL0xZbMriy34TFzS3Yn8MQpc3KBUbSjnyzukPtllD7GoomLRIjqKKrdi/4L6TfrGR3/To7NWV3g6crpWNGzIJV7OfDFkVWg48JEWj/H69JlvM4sCcI3w/xoQHBeYVUVK3xOr/z4RK80LGMNrj1kytBW/xkzX0ECqz1jHBbLkCxM7JnQp8dcUzpqKhk9qX+7x48suIDWdvx4w74bBneTQThf2qPR/uXnN9Bt715Ya94p3Ksg7SxDStNZpyzXlnWWmaN+QpgQvKnjznm7uNfazjq1K3KY22OBsmzy/cun0VbaWaZ2/WidEnbUVgvXEAKywPZi6bIAuV3UniDaBGzFd4/WTmshFt4FoHATSi2nac/IUWx9Rdzzu/qs4f4vcBaQeNHtMgGncaZo1xo6y0s5HzeXrgTVWvFYFY7TG0G/0m8W/VpT6P8dCriVwr79Q7l3RS79ASu4lbCAoKRbSw7wSw77rIR9RBw3+U2MMCxu9SvYSoArqI2JbyCS2KsVn9811sLKtv9ZC2sB+U0Ww4TOL6+B30wxrBIeSHD3LhFobZ7giZaf1bAWcVvnl1esmf6UNib59AfJ6vg/&lt;/diagram&gt;&lt;/mxfile&gt;"><defs/><g><rect x="0" y="0" width="700" height="440" fill="rgb(255, 255, 255)" stroke="none" pointer-events="all"/><path d="M 125 380.5 L 135 380.5 L 135 400.5 L 145.5 400.5 L 130 419.5 L 114.5 400.5 L 125 400.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="30" y="340" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 360px; margin-left: 31px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Select</b></span><br /><i>person_id</i></div></div></div></foreignObject><text x="130" y="364" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Select...</text></switch></g><path d="M 125 300.5 L 135 300.5 L 135 320.5 L 145.5 320.5 L 130 339.5 L 114.5 320.5 L 125 320.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="30" y="260" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 280px; margin-left: 31px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Limit</b></span><br /><i>100</i></div></div></div></foreignObject><text x="130" y="284" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Limit...</text></switch></g><path d="M 125 140.5 L 135 140.5 L 135 160.5 L 145.5 160.5 L 130 179.5 L 114.5 160.5 L 125 160.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 250 130 Q 320 130 320 205 Q 320 280 403.17 280" fill="none" stroke="#cccccc" stroke-width="24" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 433.17 280 L 403.17 295 L 403.17 265 Z" fill="#cccccc" stroke="#cccccc" stroke-width="24" stroke-miterlimit="10" pointer-events="all"/><rect x="30" y="100" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 120px; margin-left: 31px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Where</b></span><br /><i>gender_concept_id = 8507</i></div></div></div></foreignObject><text x="130" y="124" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Where...</text></switch></g><path d="M 125 60.5 L 135 60.5 L 135 80.5 L 145.5 80.5 L 130 99.5 L 114.5 80.5 L 125 80.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="30" y="20" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 40px; margin-left: 31px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>From</b></span><br /><i>person</i></div></div></div></foreignObject><text x="130" y="44" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">From...</text></switch></g><path d="M 125 220.5 L 135 220.5 L 135 240.5 L 145.5 240.5 L 130 259.5 L 114.5 240.5 L 125 240.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="30" y="180" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 200px; margin-left: 31px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Order</b></span><br /><i>year_of_birth</i></div></div></div></foreignObject><text x="130" y="204" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Order...</text></switch></g><path d="M 565 380.5 L 575 380.5 L 575 400.5 L 585.5 400.5 L 570 419.5 L 554.5 400.5 L 565 400.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="470" y="340" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 360px; margin-left: 471px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Select</b></span><br /><i>person_id</i></div></div></div></foreignObject><text x="570" y="364" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Select...</text></switch></g><path d="M 565 220.5 L 575 220.5 L 575 240.5 L 585.5 240.5 L 570 259.5 L 554.5 240.5 L 565 240.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="470" y="180" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 200px; margin-left: 471px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Limit</b></span><br /><i>100</i></div></div></div></foreignObject><text x="570" y="204" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Limit...</text></switch></g><path d="M 565 300.5 L 575 300.5 L 575 320.5 L 585.5 320.5 L 570 339.5 L 554.5 320.5 L 565 320.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="470" y="260" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 280px; margin-left: 471px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Where</b></span><br /><i>gender_concept_id = 8507</i></div></div></div></foreignObject><text x="570" y="284" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Where...</text></switch></g><path d="M 565 60.5 L 575 60.5 L 575 80.5 L 585.5 80.5 L 570 99.5 L 554.5 80.5 L 565 80.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="470" y="20" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 40px; margin-left: 471px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>From</b></span><br /><i>person</i></div></div></div></foreignObject><text x="570" y="44" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">From...</text></switch></g><path d="M 565 140.5 L 575 140.5 L 575 160.5 L 585.5 160.5 L 570 179.5 L 554.5 160.5 L 565 160.5 Z" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="470" y="100" width="200" height="40" rx="6" ry="6" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 198px; height: 1px; padding-top: 120px; margin-left: 471px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;"><span style="font-size: 16px"><b>Order</b></span><br /><i>year_of_birth</i></div></div></div></foreignObject><text x="570" y="124" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Order...</text></switch></g></g><switch><g requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"/><a transform="translate(0,-5)" xlink:href="https://www.diagrams.net/doc/faq/svg-export-text-problems" target="_blank"><text text-anchor="middle" font-size="10px" x="50%" y="100%">Text is not SVG - cannot display</text></a></switch></svg>