docs/src/two-kinds-of-sql-query-builders/100-oldest-male-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="541px" height="441px" viewBox="-0.5 -0.5 541 441" content="&lt;mxfile host=&quot;Electron&quot; modified=&quot;2022-08-29T13:17:34.337Z&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;zDRWshuRSOEt7qp-OaG3&quot; version=&quot;20.2.3&quot; type=&quot;device&quot;&gt;&lt;diagram id=&quot;YkCwad8bBgtQqS6dPUib&quot; name=&quot;Page-1&quot;&gt;7Vtbc9o4FP41PLLjC9fHQCDplGw6TXdo+sIIW9hqhOWVRbD76yvZEsYXWEMwhE1nMq11LEvH57tItpOGOVyGdxT47gOxIW4Ymh02zNuGYXT6Bv9XBKIk0GqZScChyE5Cehp4Qr+gDGoyukI2DDIdGSGYIT8btIjnQYtlYoBSss52WxCcndUHDiwEniyAi9Epspkrox1NS0/cQ+S4cuq+OrEEqrMMBC6wyXorZI4a5pASwpKjZTiEWNRO1SW5brzj7Px+2B0NfqwsB9/3J6Pe4PM/66bM9hXglcx/AKwXh5KVZ8ssWKRuDRPrBYrR9IY5UHdDoceOnt4oTF+YNE4lnlXjs65dxOCTDyxxds0JxGMuW2KZ1AJhPCSYUN624QKsMM9tEDBKXqCKe8SDpfnvLRCkDIZbCMubvINkCRmNeJcwy0NJXwXmOuVCuyVj7hYNWioIJP+czchpUfmBrGt5jYto3iLgULA8LZTfPs0fXoJpb/YcMvow1Kd3er+p9wuTQJsrQzZl1TmnfdFcYBjeCLXxWBZhQplLHOIBPCHElxn+hIxFUutgxUgW9WL+shABWVEL7klaoSMy3QsuhRgw9JrVeBlU8tIvBPFcUlK0sqwooM0AdSCTV+UA36RRiQN77zMjtE4iDh94Gdg6/66EwwwWxGPNIK75De+gd/wwPcmPHPl/PMpcBZ4gFq4qwzzZeb4rjyVz5kag+QhSAR/SgHgzfofpECjtvdMw9GMNYyehqttADnCzU/QBQyvzgRPYQDkFuhfTJ68ijb6L6/9qq+azHC5u3IaZViRbb9B1T678sazeoQFs+HAuA+idywAmaIlOrH9dCOValW/0zqj88d8/Pj2+wOjRe338qb3OIk+bNc29wk/1PEqjl9N8mQGVSvQ/jaHXusH+3Got6HQ5e50YQe/RanaKvlBas7e6QFXA9iVZv1anLqTwtFp1IOcNnfGnKwv6LF6ztThTrdfWutcrY71kI1+bjL1BF0XBzbgfTeeL4XD98OsLaF5uf13r+l16ryXL9z6lnHv11vXaVu9SNzLaF7HwELHvW8fPKQN4K8VcNKINAWxJO8VIHhkjcbvxeRsEbu6581Bfr0qYcl9vn8nY92VZv7GPKVnW8Qx2vf7duvQurHWEhN+hmx+q1t27qypPZ70zqXVflvWr9ZHyLdNp5RpBQGdkMZsjTpDzqrYg0RKOVH540i4tW71dYIGywlwBlVgZmCfi5fRmUoWmEBDfEzOAPEhlES2CMfADFHdPIi7C9gREZMXUQKrFSx5C+2vyeUKPfWA94YMFUp2CecpMxGmAkePxY4sXXsw4oFDwcgICpjAUVyTp6UYO08w78jcBahq5rVNVRDcb7tNDWvZ8tQNMfqMMAfwVWgx4ToxrFrZ4U0OJ/015mQj4YiMI6eiVF2kDULG8LHZscRLDhbp2Thjji7cEWdZjM2hci/aA//DqDIWDt3m6Q97W0zb/Ed0pGxIvYBSgGCrIoV/DoLJQD9o/qddaFcE1a8O2W8D2y+fD0I0/C4IU3YOB03LAbUszXrN54Rc43iO7yLah9zZEOuWIbEFgHoiAHCwty8GjAczp7wEGB2JVCQqwnuCZSC9upre+E1wUcOW9SV+xW7CQ50ySKzsXY0TY2KVRvXtShlQa7hwU6V+F0efpcw1GX/VzVm2LeOkXzYuqHtpIjaefXtP9o1x+X/kPd/n8aGeQcMmvNOQebd6305+HBQc6+/GsqDTcOWhh/HH2mpy96ufK+pzdLGA7vvQWvlZvT7j7Ab29VQC65OvhR/L3XUz4eP7e+WPnp7Hzyu/b6vPz4i+e/Z/M+7jXL9dv3iXfMkdGg+8ebg7U7tWb9mlet7xn0+bN9M8Oku7p326Yo98=&lt;/diagram&gt;&lt;/mxfile&gt;"><defs><clipPath id="mx-clip-310-110-30-30-0"><rect x="310" y="110" width="30" height="30"/></clipPath><clipPath id="mx-clip-346-110-164-30-0"><rect x="346" y="110" width="164" height="30"/></clipPath><clipPath id="mx-clip-346-140-164-20-0"><rect x="346" y="140" width="164" height="20"/></clipPath><clipPath id="mx-clip-310-160-30-20-0"><rect x="310" y="160" width="30" height="20"/></clipPath><clipPath id="mx-clip-346-160-164-20-0"><rect x="346" y="160" width="164" height="20"/></clipPath><clipPath id="mx-clip-346-180-164-20-0"><rect x="346" y="180" width="164" height="20"/></clipPath></defs><g><rect x="0" y="0" width="540" 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"/><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"/><path d="M 230 40 L 410 40 L 410 80" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" stroke-dasharray="3 3" pointer-events="stroke"/><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 310 110 L 310 80 L 510 80 L 510 110" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 310 110 L 310 200 L 510 200 L 510 110" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="none"/><path d="M 310 110 L 510 110" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="none"/><path d="M 340 110 L 340 140 L 340 160 L 340 180 L 340 200" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" font-weight="bold" pointer-events="none" text-anchor="middle" font-size="12px"><text x="409.5" y="99.5">person</text></g><path d="M 310 110 M 510 110 M 510 140 L 310 140" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 310 110 M 340 110 M 340 140 M 310 140" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-310-110-30-30-0)" text-anchor="middle" font-size="12px"><text x="324.5" y="129.5">PK</text></g><path d="M 340 110 M 510 110 M 510 140 M 340 140" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-346-110-164-30-0)" font-size="12px"><text x="347.5" y="129.5">person_id</text></g><path d="M 310 140 M 510 140 M 510 160 M 310 160" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 310 140 M 340 140 M 340 160 M 310 160" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 340 140 M 510 140 M 510 160 M 340 160" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-346-140-164-20-0)" font-size="12px"><text x="347.5" y="154.5">year_of_birth</text></g><path d="M 310 160 M 510 160 M 510 180 M 310 180" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 310 160 M 340 160 M 340 180 M 310 180" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-310-160-30-20-0)" text-anchor="middle" font-size="12px"><text x="324.5" y="174.5">FK</text></g><path d="M 340 160 M 510 160 M 510 180 M 340 180" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-346-160-164-20-0)" font-size="12px"><text x="347.5" y="174.5">gender_concept_id</text></g><path d="M 310 180 M 510 180 M 510 200 M 310 200" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 310 180 M 340 180 M 340 200 M 310 200" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><path d="M 340 180 M 510 180 M 510 200 M 340 200" fill="none" stroke="rgb(0, 0, 0)" stroke-linecap="square" stroke-miterlimit="10" pointer-events="none"/><g fill="rgb(0, 0, 0)" font-family="Helvetica" pointer-events="none" clip-path="url(#mx-clip-346-180-164-20-0)" font-size="12px"><text x="347.5" y="194.5">…</text></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>