<snapdata remixID="14923563"><project name="2021 - U3L11-Employee-Database" app="Snap! 11.0.8, https://snap.berkeley.edu" version="2"><notes></notes><thumbnail>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKAAAAB4CAYAAAB1ovlvAAANYklEQVR4Aeyda2wVZR7Gn7acllJqLdZArRRKK9j2tCKR2HKRm5WyRNRAiIWVaJRLtI3uB4wR3TXrBz+YsDVGjUYEN7oSL13NBlCDF1QuAWPECgYoUCjIrZQWFLAVzp7n30x7pu2pR04HzrzzJz7nnXnfd97L8//xzjkjMxMf0D/qwBV0IB76Rx24gg4ogFfQfO0a6BHA2tpaNDU1oaWl5Yro1KlT+PHHH/Hbb79pjAx3oBuA69evx1VXXYUzZ86gubn5iuj06dNITU3Fxo0bcf78ecND4O3p2QDkypeXl4fgd1J89913eOONNwSCl19+GdSWLVtQXV0t2r59u5Tv3r0bzP/qq6+wefNmvPXWW9i6dau0UR2syzaYfvTRR1i5cqUcW1NTg+eff15WWZbxeCtdu3atHMsxjBgxAvX19d6OkOGztwGYmZmJixcvijZs2ID4+HgcOHAA/fv3h8/nk9NiSkoK0tLS8NNPP8nqtGnTJhw9ehSrVq3CoEGDwBU0IyND4CLMJ0+eBEFiWzyljhw5Evv378dDDz2EJ598EllZWdJPUlISduzYgePHj0t/1jiYOhIDbTQmHLABmJCQ0LH6VFVVgbAUFhaiqKgIxcXFuHDhAkaNGiXbs2fPxtixYwUgv9+PBx98UEBauHAhhg4dKpDyO+TUqVMFqGuvvRYFBQVITk6Wcq6wK1askHrXXXcdCO38+fPBtlpbWzvG0dbWBv1jrgM2AHna44rDlCvS9OnTMWHCBBCi22+/HU899RTuuusuTJ48WVY75s+bNw8lJSUoLy/HmDFjJOVKmJ6ejiVLlkhdwlpWVoaZM2di1qxZAuvdd98tYLIsPz8fM2eUg38BCDoBtMbB1Fz7dWbdACR8DPoPG9agbmkhji3zY9Ozc7DuuYX47z/uw/+efUC2uU8x78NnFtjymB+pji4rlj6GHPhETv1W/1aqITLbgR4BZPBPH9qD/AwfDt9SiaLHVmJC5XJH1DLvbfiuyUaKL77jtMv+Q2V2CLw9OxuAtIKrHwUEUDvgZuROrZCViXlOaMj12Wj0V7BrATC0D0LIfSnUDyMdsAHIgHcKGJqT5yh8hItqHJgr5nK7s/+A9C0F+tGXDsRUW70AGEC/pAECAaGw4HAiZZt0hf30JJapzHTABiCnSBgonoItGLhviXnWNtO+2g/tm+2GimUqMx2wAUiYOhVEMNB+GiQMzGdqqa/3aS/b7Crmq8x1oBuAoYARBmvf6ZQWh+uDZSozHbAByCkSOiq4/gV3O1fAcHD0RX57f8Eegysut7sqOBD9z1AHbAB2DTz3+wKwSNqgv+yvJ7FMZaYD3QC0YAkuRh3X5QgF86NNwx3Ptmkv067iMSxTmelANwAZcCp4QuwAsCsUTuzTXvbbk1imMtMBG4CcYk8AEDjmO5mG65v9skxlpgM2ABlsQkaFnoK577Rob099cEwsU5npQDcAGXDqcp6C2/sL9hiknttdZab1Ois6YAOQGdYqZEFg7TudhvYd2hfHwTKVmQ7YAGSwO8UVCfL/gkOBcGqb9nb2HZAfQNY+y9wtHX04B7oBSMCswDPlvhOqrKyUf23Nf5rP9jlAq7/QlNssU5npgA1ATpEBbweicxXiXW4NDQ22VYn1otELL7wA3gl32223ySrLvtkv2+yaskxlpgM2ABn8TkGA27dvH4YNGyY3DfFeYcJB8Z4Rpl3F2zTr6+vRr18/AYvlZ8+eRWJiYsc+86hJkyZh165dkk97O/vuhJ95LFOZ6UA3AAkGxcAz5S2VL774Is6dOyf36DKP4q2ar732Gng/8Oeff47ly5fjs88+w/fffw/rnuGDBw+CoHL13LNnj4DGYyne2kn4cnNzBXTaa/XJcor7FMtUZjpgA5BTZMCp4PqHwwf2gXeoLV26VO54GzhwYAdErMP7fktLSzF69GjJ591wfr8fR44ckbvmWP/XX3/F77//Lk9bIFSUBR/hJpiJgVZ2LW2wXUusy20p1A8jHbAByMdgMOCWRrbV4dtvt+GXX37Bp59+itAb13kDOW/ZZF2Cdv/998tpt6SkBNzmbZzMJ0Rc5Xg/MLevvvpqEDrCt3fvXrlpfUz922Iu2+oqPiZECvXDlQ780aBtADY3N4M3ghOUuIREpMefw9zGfyO17hOcP3NKnlzApxf0JJ5mudJ98cUXvdb7+uuvZYXkc1/6n9iJhNWLMSrhuIyT/XYV/1JIoX4Y6YANQJ5O+fgMPhyo+C/3oaHgPpzPm4acjBRM6V+P6cl7+1QjfU1IHjkeB3Nm4YcBN8t3QWsF5Kmbj/yYMmWKkcbrpNodsAHILD6xgL9Om1tasHdQCfZmTb8sOtJ0Rr5v8jsnV8Fx48ZhwYIFHJLKYAe6Aci58jkufCzHnXfeiSuhGTNmYPDgwRyKynAHegTQ8Dnr9GLIAQUwhoLhxaGYC6AXo+nCOSuALgyaSUNWAE2KpgvnogC6MGgmDVkBNCmaLpyLAujCoJk0ZAXQpGi2z8VVnwqgq8Jl3mAVQPNi6qoZKYCuCpd5g1UAzYupq2akALoqXOYNVgE0L6aumlGfAuiqmetgY8IBBTAmwuDdQSiA3o19TMxcAYyJMHh3EAqgd2MfEzNXAGMiDN4dhAIYJvbvv/8+Xn31VfD5NmGqhGTr5qU6oACGce6OO+6Qhy09+uij8hzDl156SYDUJzWEMewSsxXAMMbxmTSPPPII+Eg63ie9fv16fPzxx6ioqEB5eTlWr16Nd955J8zRmh2pAwpgpE6F1IuPb7ctISEhJFc3L8WBdicv5UjDj+HzcXjaTU1NxYkTJ1BWVgY+seHdd9/F2rVrce+992Lu3LmGu+D89BTAMB7zcXTTpk0DHyX8zTff4OGHH8aiRYvg8/nCHKHZl+KAAhjGtTlz5mDx4sXIzs4OU0Oz6UC0UgCjdVCPj8oBBTAq+/TgaB1QAKN1UI+PygEFMCr79OBoHVAAo3VQj4/KAQUwKvv04GgdcC+A0c5cj48JBxTAmAiDdwehAHo39jExcwUwJsLg3UEogN6NfUzMXAGMiTB4dxAKoPtib9SIFUCjwum+ySiA7ouZUSNWAI0Kp/smowC6L2ZGjVgBNCqc7puMAui+mBk14j8FoFEz18nEhAMKYEyEwbuDUAC9G/uYmLkCGBNh8O4gFEDvxj4mZq4AxkQYvDsIBTCi2GslpxxQAJ1yVtuNyAEFMCKbtJJTDiiATjmr7UbkgAIYkU1aySkHFECnnNV2I3JAAYzIJu9WcnrmCqDTDmv7vTqgAPZqjxY67YAC6LTD2n6vDiiAvdqjhU470COAtbW1aGpqQktLy2XVsWPHsGPHDqfnrO3HkAPdAOQbgfiWIL4hqLm5Gc2XUXwNVnJyMrZu3RpDFulQnHTABiBXvry8PAQCAWzZsgWvvPIKNm/ejHXr1smrqWpqamS/uroaO3fuFFBYd+PGjbK9ZMkSOXbFihV44okn8Prrr6OxsRGsz7w333wTa9asAdt57733pC6PDxXfQpSUlITmIPhOTlzbjg0HbABmZmbi4sWLHeJLWYYPH45t27bJaHNzc7Fr1y6kpaXhyy+/RENDg9Tdvn27vMCFL3ZhRQK1f/9+3HDDDVLOfebzrUMnT55EYmIiUlJSpCy0P2ub9Xbv3s1DVIY7YAOQ7z4jLFR+fj4I388//4xx48ahoKAA/I42ceJEFBcXIyMjA7feequsYnyD0OjRo3HjjTfK/vAgtB988IGsknyt1dNPP42ioiLwWL/fL8fyBTDsJ5za2toMt16nRwdsABIGrkJMCdg999yDyZMng+n48eMxe/ZsEDTmVVZWynZ6ejoofm8kqFwdWZ/f5R5//HFUVVUhLi4OXB1HjBiBSZMmyXvXSktL5TgeS7WePyfwWv1zDBygymwHugHIwBOCHzasQd3SQhxb5semZ+dg3XMLbar5+1/x4TMLbHld60Syf3RZsfQx5MAnckq2+jfbdp2d5UCPAB46dAgDU9OQM2Mx2mb8E8V/W4WJVf9yRKfn/wcZ0xYhMKQQra2t8r2SEFLWIDU11wEbgJxmXV0d+GNj2E2lODv2AaTdVCanRgLhhDKHDpN+zlyTj9TUVOTk5HRAyPF4UJ6asg3Aw4cPo7CwUID7M5dheImFl2v66jIMv3/GxcV5KhBenawNwKysLPkexu+AVKSXYQYPHiyrF39o0EiulNFchuEPGl4PZFsqsx2wAXipl2HKy8vlEkxfXoYx23adneWADUCuXFz5mPI0yMspvOTC9I8uw/BSil6GsWzVNFIHugFI+AihXoaJ1EKtF40DPQJICE8f2oP8DB8O31KJosdWYkLlckfUMu9t+K7JRoovTn78sG9L0UxMj3WHAzYAOWSufhQQQO2Am5E7tcL2w4Rlfakh12ej0V/BrgVAq21CKJn6YbQDNgAZ9E4BQ3PyHIXPgq1xYK6YzH2rf8nQD+Md6AXAAPolDRAACYUFhxMp26TT7CdUzFOZ7YANQE6VMFA8BVswcN8S86xtpn21H9q31S7zVGY7YAOQMHUqiGAgICugBQRTS6xnbTONdp82sw1L3FeZ78D/AQAA//+R25dOAAAABklEQVQDAIuCug/gHs4ZAAAAAElFTkSuQmCC</thumbnail><scenes select="1"><scene name="2021 - U3L11-Employee-Database"><notes></notes><hidden></hidden><headers></headers><code></code><blocks><block-definition s="label %&apos;text&apos; of size %&apos;size&apos;" type="command" category="pen"><comment x="0" y="0" w="90" collapsed="false">LABEL will stamp text on the stage at the given font size. The direction of the text is the direction the sprite is facing, and color will match the pen color.</comment><header></header><code></code><translations></translations><inputs><input type="%txt">Hello!</input><input type="%n">12</input></inputs><script><block s="doRun"><block s="reportJSFunction"><list><l>text</l><l>size</l></list><l>var stage = this.parentThatIsA(StageMorph),&#xD;    context = stage.penTrails().getContext(&apos;2d&apos;),&#xD;    rotation = radians(this.direction() - 90),&#xD;    trans = new Point(&#xD;      this.center().x - stage.left(),&#xD;      this.center().y - stage.top()&#xD;    ),&#xD;    isWarped = this.Warped,&#xD;    len,&#xD;    pos;&#xD;&#xD;if (isWarped) {endWarp(); }&#xD;context.save();&#xD;context.font = size + &apos;px monospace&apos;;&#xD;context.textAlign = &apos;left&apos;;&#xD;context.textBaseline = &apos;alphabetic&apos;;&#xD;context.fillStyle = this.color.toString();&#xD;len = context.measureText(text).width;&#xD;trans = trans.multiplyBy(1 / stage.scale);&#xD;context.translate(trans.x, trans.y);&#xD;context.rotate(rotation);&#xD;context.fillText(text, 0, 0);&#xD;context.translate(-trans.x, -trans.y);&#xD;context.restore();&#xD;pos = new Point(&#xD;  len * Math.sin(radians(this.direction())),&#xD;  len * Math.cos(radians(this.direction())));&#xD;pos = pos.add(new Point(this.xPosition(), this.yPosition()));&#xD;this.gotoXY(pos.x, pos.y, false);&#xD;this.changed();&#xD;if (isWarped) {this.startWarp(); }&#xD;stage.changed();</l></block><list><block var="text"/><block var="size"/></list></block></script></block-definition><block-definition s="map %&apos;function&apos; over %&apos;lists&apos;" type="reporter" category="lists"><header></header><code></code><translations></translations><inputs><input type="%repRing"></input><input type="%mult%l"></input></inputs><script><block s="doWarp"><script><block s="doDeclareVariables"><list><l>mapone</l><l>mapmany</l></list></block><block s="doSetVar"><l>mapone</l><block s="reifyScript"><script><block s="doIf"><custom-block s="empty? %l"><block var="data"/></custom-block><script><block s="doReport"><block s="reportNewList"><list></list></block></block></script><list></list></block><block s="doReport"><block s="reportCONS"><block s="evaluate"><block var="function"/><list><block s="reportListItem"><l>1</l><block var="data"/></block></list></block><block s="evaluate"><block var="mapone"/><list><block s="reportCDR"><block var="data"/></block></list></block></block></block></script><list><l>data</l></list></block></block><block s="doSetVar"><l>mapmany</l><block s="reifyScript"><script><block s="doIf"><custom-block s="empty? %l"><block s="reportListItem"><l>1</l><block var="data lists"/></block></custom-block><script><block s="doReport"><block s="reportNewList"><list></list></block></block></script><list></list></block><block s="doReport"><block s="reportCONS"><block s="evaluate"><block var="function"/><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><block s="reportListItem"><l>1</l><l/></block></autolambda><list></list></block><list><block var="data lists"/></list></custom-block></block><block s="evaluate"><block var="mapmany"/><list><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><block s="reportCDR"><l/></block></autolambda><list></list></block><list><block var="data lists"/></list></custom-block></list></block></block></block></script><list><l>data lists</l></list></block></block><block s="doIfElse"><custom-block s="empty? %l"><block s="reportCDR"><block var="lists"/></block></custom-block><script><block s="doReport"><block s="evaluate"><block var="mapone"/><list><block s="reportListItem"><l>1</l><block var="lists"/></block></list></block></block></script><script><block s="doReport"><block s="evaluate"><block var="mapmany"/><list><block var="lists"/></list></block></block></script></block></script></block></script></block-definition><block-definition s="empty? %&apos;data&apos;" type="predicate" category="lists"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doReport"><block s="reportVariadicEquals"><list><block var="data"/><block s="reportNewList"><list></list></block></list></block></block></script></block-definition><block-definition s="keep items such that %&apos;pred&apos; from %&apos;data&apos;" type="reporter" category="lists"><header></header><code></code><translations></translations><inputs><input type="%predRing"></input><input type="%l"></input></inputs><script><block s="doWarp"><script><block s="doIf"><custom-block s="empty? %l"><block var="data"/></custom-block><script><block s="doReport"><block s="reportNewList"><list></list></block></block></script><list></list></block><block s="doIfElse"><block s="evaluate"><block var="pred"/><list><block s="reportListItem"><l>1</l><block var="data"/></block></list></block><script><block s="doReport"><block s="reportCONS"><block s="reportListItem"><l>1</l><block var="data"/></block><custom-block s="keep items such that %predRing from %l"><block var="pred"/><block s="reportCDR"><block var="data"/></block></custom-block></block></block></script><script><block s="doReport"><custom-block s="keep items such that %predRing from %l"><block var="pred"/><block s="reportCDR"><block var="data"/></block></custom-block></block></script></block></script></block></script></block-definition><block-definition s="combine with %&apos;function&apos; items of %&apos;data&apos;" type="reporter" category="lists"><header></header><code></code><translations></translations><inputs><input type="%repRing"></input><input type="%l"></input></inputs><script><block s="doWarp"><script><block s="doIf"><custom-block s="empty? %l"><block s="reportCDR"><block var="data"/></block></custom-block><script><block s="doReport"><block s="reportListItem"><l>1</l><block var="data"/></block></block></script><list></list></block><block s="doReport"><block s="evaluate"><block var="function"/><list><block s="reportListItem"><l>1</l><block var="data"/></block><custom-block s="combine with %repRing items of %l"><block var="function"/><block s="reportCDR"><block var="data"/></block></custom-block></list></block></block></script></block></script></block-definition><block-definition s="if %&apos;test&apos; then %&apos;true&apos; else %&apos;false&apos;" type="reporter" category="control"><header></header><code></code><translations></translations><inputs><input type="%b"></input><input type="%anyUE"></input><input type="%anyUE"></input></inputs><script><block s="doIfElse"><block var="test"/><script><block s="doReport"><block s="evaluate"><block var="true"/><list></list></block></block></script><script><block s="doReport"><block s="evaluate"><block var="false"/><list></list></block></block></script></block></script></block-definition><block-definition s="for %&apos;i&apos; = %&apos;start&apos; to %&apos;end&apos; %&apos;action&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%upvar"></input><input type="%n">1</input><input type="%n">10</input><input type="%cs"></input></inputs><script><block s="doDeclareVariables"><list><l>step</l><l>tester</l></list></block><block s="doIfElse"><block s="reportVariadicGreaterThan"><list><block var="start"/><block var="end"/></list></block><script><block s="doSetVar"><l>step</l><l>-1</l></block><block s="doSetVar"><l>tester</l><block s="reifyReporter"><autolambda><block s="reportVariadicLessThan"><list><block var="i"/><block var="end"/></list></block></autolambda><list></list></block></block></script><script><block s="doSetVar"><l>step</l><l>1</l></block><block s="doSetVar"><l>tester</l><block s="reifyReporter"><autolambda><block s="reportVariadicGreaterThan"><list><block var="i"/><block var="end"/></list></block></autolambda><list></list></block></block></script></block><block s="doSetVar"><l>i</l><block var="start"/></block><block s="doUntil"><block s="evaluate"><block var="tester"/><list></list></block><script><block s="doRun"><block var="action"/><list></list></block><block s="doChangeVar"><l>i</l><block var="step"/></block></script></block></script></block-definition><block-definition s="join words %&apos;words&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%mult%txt"></input></inputs><script><block s="doWarp"><script><block s="doIf"><custom-block s="empty? %l"><block s="reportCDR"><block var="words"/></block></custom-block><script><block s="doReport"><block s="reportListItem"><l>1</l><block var="words"/></block></block></script><list></list></block><block s="doReport"><block s="reportJoinWords"><list><block s="reportListItem"><l>1</l><block var="words"/></block><l> </l><custom-block s="join words %mult%txt"><block s="reportCDR"><block var="words"/></block></custom-block></list></block></block></script></block></script></block-definition><block-definition s="list $arrowRight sentence %&apos;data&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doWarp"><script><block s="doReport"><custom-block s="join words %mult%txt"><block var="data"/></custom-block></block></script></block></script></block-definition><block-definition s="sentence $arrowRight list %&apos;text&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%txt"></input></inputs><script><block s="doWarp"><script><block s="doReport"><block s="reportTextSplit"><block var="text"/><l><option>whitespace</option></l></block></block></script></block></script></block-definition><block-definition s="catch %&apos;tag&apos; %&apos;action&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%upvar"></input><input type="%cs"></input></inputs><script><block s="doCallCC"><block s="reifyScript"><script><block s="doSetVar"><l>tag</l><block var="cont"/></block><block s="doRun"><block var="action"/><list></list></block></script><list><l>cont</l></list></block></block></script></block-definition><block-definition s="throw %&apos;cont&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%s">catchtag</input></inputs><script><block s="doRun"><block var="cont"/><list></list></block></script></block-definition><block-definition s="catch %&apos;tag&apos; %&apos;value&apos;" type="reporter" category="control"><header></header><code></code><translations></translations><inputs><input type="%upvar"></input><input type="%anyUE"></input></inputs><script><block s="doCallCC"><block s="reifyScript"><script><block s="doSetVar"><l>tag</l><block var="cont"/></block><block s="doReport"><block s="evaluate"><block var="value"/><list></list></block></block></script><list><l>cont</l></list></block></block></script></block-definition><block-definition s="throw %&apos;tag&apos; %&apos;value&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%s">catchtag</input><input type="%s"></input></inputs><script><block s="doRun"><block var="tag"/><list><block var="value"/></list></block></script></block-definition><block-definition s="for each %&apos;item&apos; of %&apos;data&apos; %&apos;action&apos;" type="command" category="lists"><header></header><code></code><translations></translations><inputs><input type="%upvar"></input><input type="%l"></input><input type="%cs"></input></inputs><script><block s="doUntil"><custom-block s="empty? %l"><block var="data"/></custom-block><script><block s="doSetVar"><l>item</l><block s="reportListItem"><l>1</l><block var="data"/></block></block><block s="doRun"><block var="action"/><list><block s="reportListItem"><l>1</l><block var="data"/></block></list></block><block s="doSetVar"><l>data</l><block s="reportCDR"><block var="data"/></block></block></script></block></script></block-definition><block-definition s="if %&apos;test&apos; do %&apos;action&apos; and pause all $pause-1-255-220-0" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%boolUE"></input><input type="%cs"></input></inputs><script><block s="doDeclareVariables"><list><l>breakpoint</l></list></block><block s="doIf"><block s="evaluate"><block var="test"/><list></list></block><script><block s="doSetVar"><l>breakpoint</l><block var="test"/></block><block s="doShowVar"><l>breakpoint</l></block><block s="doRun"><block var="action"/><list></list></block><block s="doPauseAll"></block><block s="doHideVar"><l></l></block></script><list></list></block></script></block-definition><block-definition s="word $arrowRight list %&apos;word&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%txt"></input></inputs><script><block s="doWarp"><script><block s="doReport"><block s="reportTextSplit"><block var="word"/><l><option>letter</option></l></block></block></script></block></script></block-definition><block-definition s="ignore %&apos;x&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%s"></input></inputs></block-definition><block-definition s="tell %&apos;sprite&apos; to %&apos;action&apos;" type="command" category="control"><header></header><code></code><translations></translations><inputs><input type="%s">Sprite</input><input type="%cs"></input></inputs><script><block s="doRun"><block s="reportAttributeOf"><block var="action"/><block var="sprite"/></block><list></list></block></script></block-definition><block-definition s="ask %&apos;sprite&apos; for %&apos;expression&apos;" type="reporter" category="control"><header></header><code></code><translations></translations><inputs><input type="%s">Sprite</input><input type="%repRing"></input></inputs><script><block s="doReport"><block s="evaluate"><block s="reportAttributeOf"><block var="expression"/><block var="sprite"/></block><list></list></block></block></script></block-definition><block-definition s="list $arrowRight word %&apos;list&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doWarp"><script><block s="doReport"><block s="reportJoinWords"><block var="list"/></block></block></script></block></script></block-definition><block-definition s="employee, name: %&apos;name&apos; job title: %&apos;title&apos; salary: %&apos;salary&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%s"></input><input type="%s"></input><input type="%s"></input></inputs><script><block s="doReport"><block s="reportNewList"><list><block var="name"/><block var="title"/><block var="salary"/></list></block></block></script></block-definition><block-definition s="name from employee %&apos;employee&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doReport"><block s="reportListItem"><l>1</l><block var="employee"/></block></block></script></block-definition><block-definition s="job title from employee %&apos;employee&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doReport"><block s="reportListItem"><l>2</l><block var="employee"/></block></block></script></block-definition><block-definition s="salary from employee %&apos;employee&apos;" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs><input type="%l"></input></inputs><script><block s="doReport"><block s="reportListItem"><l>3</l><block var="employee"/></block></block></script></block-definition><block-definition s="paid less than 100,000" type="reporter" category="operators"><header></header><code></code><translations></translations><inputs></inputs><script><block s="doDeclareVariables"><list><l>find total less than 100k</l></list></block><block s="doSetVar"><l>find total less than 100k</l><block s="reportNewList"><list></list></block></block><block s="doWarp"><script><block s="doForEach"><l>item</l><block var="employee database"/><script><block s="doIf"><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><block var="employee database"/></custom-block><l>100,000</l></list></block><script><block s="doAddToList"><block var="item"/><block var="find total less than 100k"/></block><block s="doReport"><block var="find total less than 100k"/></block></script><list></list></block></script></block></script></block><block s="doReport"><block s="reportCombine"><block var="employee database"/><block s="reifyReporter"><autolambda><block s="reportVariadicSum"><list><l></l><l></l></list></block></autolambda><list></list></block></block></block></script></block-definition></blocks><primitives></primitives><stage name="Stage" width="480" height="360" costume="0" color="255,255,255,1" tempo="60" threadsafe="false" penlog="false" volume="100" pan="0" lines="round" ternary="true" hyperops="true" codify="false" inheritance="false" sublistIDs="false" id="636"><pentrails>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeAAAAFoCAYAAACPNyggAAAQAElEQVR4AezVC27kNhAEUCP3P3SC/NZeez6SSDWb9YJg1zsjkV2vDdQfH/4jQIAAAQIEbhdQwLeTu5AAAQIECHx8ZBew3wACBAgQIFAkoICL4F1LgAABAtkCCjh3/5ITIECAQKGAAi7EdzUBAgQI5Aoo4NzdZyeXngABAsUCCrh4Aa4nQIAAgUwBBZy5d6mzBaQnQGABAQW8wBKMQIAAAQJ5Ago4b+cSE8gWkJ7AIgIKeJFFGIMAAQIEsgQUcNa+pSVAIFtA+oUEFPBCyzAKAQIECOQIKOCcXUtKgACBbIHF0ivgxRZiHAIECBDIEFDAGXuWkgABAgQWE7i5gBdLbxwCBAgQIFAkoICL4F1LgAABAtkCCvjG/buKAAECBAj8J6CA/5PwNwECBAgQuFFAAd+InX2V9AQIECDwWUABf9bwMwECBAgQuElAAd8E7ZpsAekJECDwu4AC/l3EvwkQIECAwA0CCvgGZFcQyBaQngCBnwQU8E8qPiNAgAABApMFFPBkYMcTIJAtID2BRwIK+JGMzwkQIECAwEQBBTwR19EECBDIFpD+mYACfqbjOwIECBAgMElAAU+CdSwBAgQIZAu8Sq+AXwn5ngABAgQITBBQwBNQHUmAAAECBF4J7F3Ar9L7ngABAgQIFAko4CJ41xIgQIBAtoAC3nf/khEgQIDAwgIKeOHlGI0AAQIE9hVQwPvuNjuZ9AQIEFhcQAEvviDjESBAgMCeAgp4z71KlS0gPQECDQQUcIMlGZEAAQIE9hNQwPvtVCIC2QLSE2gioICbLMqYBAgQILCXgALea5/SECCQLSB9IwEF3GhZRiVAgACBfQQU8D67lIQAAQLZAs3SK+BmCzMuAQIECOwhoID32KMUBAgQINBMYHABN0tvXAIECBAgUCSggIvgXUuAAAEC2QIKeOD+HUWAAAECBN4VUMDvSnmOAAECBAgMFFDAAzGzj5KeAAECBI4IKOAjWp4lQIAAAQKDBBTwIEjHZAtIT4AAgaMCCviomOcJECBAgMAAAQU8ANERBLIFpCdA4IyAAj6j5h0CBAgQIHBRQAFfBPQ6AQLZAtITOCuggM/KeY8AAQIECFwQUMAX8LxKgACBbAHprwgo4Ct63iVAgAABAicFFPBJOK8RIECAQLbA1fQK+Kqg9wkQIECAwAkBBXwCzSsECBAgQOCqQO8Cvpre+wQIECBAoEhAARfBu5YAAQIEsgUUcN/9m5wAAQIEGgso4MbLMzoBAgQI9BVQwH13lz259AQIEGguoICbL9D4BAgQINBTQAH33JupswWkJ0BgAwEFvMESRSBAgACBfgIKuN/OTEwgW0B6ApsIKOBNFikGAQIECPQSUMC99mVaAgSyBaTfSEABb7RMUQgQIECgj4AC7rMrkxIgQCBbYLP0CnizhYpDgAABAj0EFHCPPZmSAAECBDYTOFjAm6UXhwABAgQIFAko4CJ41xIgQIBAtoACPrB/jxIgQIAAgVECCniUpHMIECBAgMABAQV8ACv7UekJECBAYKSAAh6p6SwCBAgQIPCmgAJ+E8pj2QLSEyBAYLSAAh4t6jwCBAgQIPCGgAJ+A8kjBLIFpCdAYIaAAp6h6kwCBAgQIPBCQAG/API1AQLZAtITmCWggGfJOpcAAQIECDwRUMBPcHxFgACBbAHpZwoo4Jm6ziZAgAABAg8EFPADGB8TIECAQLbA7PQKeLaw8wkQIECAwA8CCvgHFB8RIECAAIHZAmsX8Oz0zidAgAABAkUCCrgI3rUECBAgkC2ggNfdv8kIECBAYGMBBbzxckUjQIAAgXUFFPC6u8meTHoCBAhsLqCAN1+weAQIECCwpoACXnMvpsoWkJ4AgQABBRywZBEJECBAYD0BBbzeTkxEIFtAegIhAgo4ZNFiEiBAgMBaAgp4rX2YhgCBbAHpgwQUcNCyRSVAgACBdQQU8Dq7MAkBAgSyBcLSK+CwhYtLgAABAmsIKOA19mAKAgQIEAgT+K2Aw9KLS4AAAQIEigQUcBG8awkQIEAgW0ABf9q/HwkQIECAwF0CCvguafcQIECAAIFPAgr4E0b2j9ITIECAwJ0CCvhObXcRIECAAIF/BRTwvxD+yhaQngABAncLKOC7xd1HgAABAgT+ElDAfyH4n0C2gPQECFQIKOAKdXcSIECAQLyAAo7/FQBAIFtAegJVAgq4St69BAgQIBAtoICj1y88AQLZAtJXCijgSn13EyBAgECsgAKOXb3gBAgQyBaoTq+AqzfgfgIECBCIFFDAkWsXmgABAgSqBWoLuDq9+wkQIECAQJGAAi6Cdy0BAgQIZAso4Lr9u5kAAQIEggUUcPDyRSdAgACBOgEFXGeffbP0BAgQCBdQwOG/AOITIECAQI2AAq5xd2u2gPQECBD4UMB+CQgQIECAQIGAAi5AdyWBaAHhCRD4W0AB/83gDwIECBAgcK+AAr7X220ECGQLSE/gfwEF/D+FHwgQIECAwH0CCvg+azcRIEAgW0D6LwIK+AuHfxAgQIAAgXsEFPA9zm4hQIAAgWyBb+kV8DcSHxAgQIAAgfkCCni+sRsIECBAgMA3gagC/pbeBwQIECBAoEhAARfBu5YAAQIEsgUUcMz+BSVAgACBlQQU8ErbMAsBAgQIxAgo4JhVZweVngABAqsJKODVNmIeAgQIEIgQUMARaxYyW0B6AgRWFFDAK27FTAQIECCwvYAC3n7FAhLIFpCewKoCCnjVzZiLAAECBLYWUMBbr1c4AgSyBaRfWUABr7wdsxEgQIDAtgIKeNvVCkaAAIFsgdXTK+DVN2Q+AgQIENhSQAFvuVahCBAgQGB1gbkFvHp68xEgQIAAgSIBBVwE71oCBAgQyBZQwPP272QCBAgQIPBQQAE/pPEFAQIECBCYJ6CA59lmnyw9AQIECDwVUMBPeXxJgAABAgTmCCjgOa5OzRaQngABAi8FFPBLIg8QIECAAIHxAgp4vKkTCWQLSE+AwFsCCvgtJg8RIECAAIGxAgp4rKfTCBDIFpCewNsCCvhtKg8SIECAAIFxAgp4nKWTCBAgkC0g/SEBBXyIy8MECBAgQGCMgAIe4+gUAgQIEMgWOJxeAR8m8wIBAgQIELguoICvGzqBAAECBAgcFtiqgA+n9wIBAgQIECgSUMBF8K4lQIAAgWwBBbzN/gUhQIAAgU4CCrjTtsxKgAABAtsIKOBtVpkdRHoCBAh0E1DA3TZmXgIECBDYQkABb7FGIbIFpCdAoKOAAu64NTMTIECAQHsBBdx+hQIQyBaQnkBXAQXcdXPmJkCAAIHWAgq49foMT4BAtoD0nQUUcOftmZ0AAQIE2goo4LarMzgBAgSyBbqnV8DdN2h+AgQIEGgpoIBbrs3QBAgQINBd4FoBd09vfgIECBAgUCSggIvgXUuAAAEC2QIK+Pz+vUmAAAECBE4LKODTdF4kQIAAAQLnBRTwebvsN6UnQIAAgUsCCvgSn5cJECBAgMA5AQV8zs1b2QLSEyBA4LKAAr5M6AACBAgQIHBcQAEfN/MGgWwB6QkQGCKggIcwOoQAAQIECBwTUMDHvDxNgEC2gPQEhgko4GGUDiJAgAABAu8LKOD3rTxJgACBbAHphwoo4KGcDiNAgAABAu8JKOD3nDxFgAABAtkCw9Mr4OGkDiRAgAABAq8FFPBrI08QIECAAIHhAq0KeHh6BxIgQIAAgSIBBVwE71oCBAgQyBZQwG32b1ACBAgQ2ElAAe+0TVkIECBAoI2AAm6zquxBpSdAgMBuAgp4t43KQ4AAAQItBBRwizUZMltAegIEdhRQwDtuVSYCBAgQWF5AAS+/IgMSyBaQnsCuAgp4183KRYAAAQJLCyjgpddjOAIEsgWk31lAAe+8XdkIECBAYFkBBbzsagxGgACBbIHd0yvg3TcsHwECBAgsKaCAl1yLoQgQIEBgd4HnBbx7evkIECBAgECRgAIugnctAQIECGQLKODH+/cNAQIECBCYJqCAp9E6mAABAgQIPBZQwI9tsr+RngABAgSmCijgqbwOJ0CAAAECPwso4J9dfJotID0BAgSmCyjg6cQuIECAAAEC3wUU8HcTnxDIFpCeAIFbBBTwLcwuIUCAAAECXwUU8FcP/yJAIFtAegK3CSjg26hdRIAAAQIEfgko4F8WfiJAgEC2gPS3CijgW7ldRoAAAQIE/hFQwP84+JMAAQIEsgVuT6+Abyd3IQECBAgQ+PhQwH4LCBAgQIBAgcBSBVyQ35UECBAgQKBEQAGXsLuUAAECBNIFFPAyvwEGIUCAAIEkAQWctG1ZCRAgQGAZAQW8zCqyB5GeAAECaQIKOG3j8hIgQIDAEgIKeIk1GCJbQHoCBBIFFHDi1mUmQIAAgXIBBVy+AgMQyBaQnkCqgAJO3bzcBAgQIFAqoIBL+V1OgEC2gPTJAgo4efuyEyBAgECZgAIuo3cxAQIEsgXS0yvg9N8A+QkQIECgREABl7C7lAABAgSyBT4+FHD6b4D8BAgQIFAioIBL2F1KgAABAukCyQWcvnv5CRAgQKBQQAEX4ruaAAECBHIFFHDq7uUmQIAAgVIBBVzK73ICBAgQSBVQwKmbz84tPQECBMoFFHD5CgxAgAABAokCCjhx6zJnC0hPgMASAgp4iTUYggABAgTSBBRw2sblJZAtID2BZQQU8DKrMAgBAgQIJAko4KRty0qAQLaA9EsJKOCl1mEYAgQIEEgRUMApm5aTAAEC2QLLpVfAy63EQAQIECCQIKCAE7YsIwECBAgsJ3BrAS+X3kAECBAgQKBIQAEXwbuWAAECBLIFFPBt+3cRAQIECBD4JaCAf1n4iQABAgQI3CaggG+jzr5IegIECBD4KqCAv3r4FwECBAgQuEVAAd/C7JJsAekJECDwXUABfzfxCQECBAgQmC6ggKcTu4BAtoD0BAj8LKCAf3bxKQECBAgQmCqggKfyOpwAgWwB6Qk8FlDAj218Q4AAAQIEpgko4Gm0DiZAgEC2gPTPBRTwcx/fEiBAgACBKQIKeAqrQwkQIEAgW+B1egX82sgTBAgQIEBguIACHk7qQAIECBAg8Fpg5wJ+nd4TBAgQIECgSEABF8G7lgABAgSyBRTwrvuXiwABAgSWFlDAS6/HcAQIECCwq4AC3nWz2bmkJ0CAwPICCnj5FRmQAAECBHYUUMA7blWmbAHpCRBoIaCAW6zJkAQIECCwm4AC3m2j8hDIFpCeQBsBBdxmVQYlQIAAgZ0EFPBO25SFAIFsAelbCSjgVusyLAECBAjsIqCAd9mkHAQIEMgWaJdeAbdbmYEJECBAYAcBBbzDFmUgQIAAgXYCQwu4XXoDEyBAgACBIgEFXATvWgIECBDIFlDAw/bvIAIECBAg8L6AAn7fypMECBAgQGCYgAIeRpl9kPQECBAgcExAAR/z8jQBAgQIEBgioICHMDokW0B6AgQIHBdQwMfNvEGAAAECBC4LKODLhA4gkC0gPQECv+uE6gAAAkNJREFU5wQU8Dk3bxEgQIAAgUsCCvgSn5cJEMgWkJ7AeQEFfN7OmwQIECBA4LSAAj5N50UCBAhkC0h/TUABX/PzNgECBAgQOCWggE+xeYkAAQIEsgWup1fA1w2dQIAAAQIEDgso4MNkXiBAgAABAtcFOhfw9fROIECAAAECRQIKuAjetQQIECCQLaCAu+7f3AQIECDQWkABt16f4QkQIECgq4AC7rq57LmlJ0CAQHsBBdx+hQIQIECAQEcBBdxxa2bOFpCeAIEtBBTwFmsUggABAgS6CSjgbhszL4FsAekJbCOggLdZpSAECBAg0ElAAXfallkJEMgWkH4rAQW81TqFIUCAAIEuAgq4y6bMSYAAgWyB7dIr4O1WKhABAgQIdBBQwB22ZEYCBAgQ2E7gUAFvl14gAgQIECBQJKCAi+BdS4AAAQLZAgr47f17kAABAgQIjBNQwOMsnUSAAAECBN4WUMBvU2U/KD0BAgQIjBVQwGM9nUaAAAECBN4SUMBvMXkoW0B6AgQIjBdQwONNnUiAAAECBF4KKOCXRB4gkC0gPQECcwQU8BxXpxIgQIAAgacCCvgpjy8JEMgWkJ7APAEFPM/WyQQIECBA4KGAAn5I4wsCBAhkC0g/V0ABz/V1OgECBAgQ+FFAAf/I4kMCBAgQyBaYn14Bzzd2AwECBAgQ+CaggL+R+IAAAQIECMwXWLmA56d3AwECBAgQKBJQwEXwriVAgACBbAEFvOr+zUWAAAECWwso4K3XKxwBAgQIrCrwJwAAAP//lVwoVAAAAAZJREFUAwDU5ALRcl29HAAAAABJRU5ErkJggg==</pentrails><costumes><list struct="atomic" id="637"></list></costumes><sounds><list struct="atomic" id="638"></list></sounds><variables></variables><blocks></blocks><scripts></scripts><sprites select="1"><sprite name="Sprite" idx="1" x="0" y="-1.1368683772161603e-13" heading="90" scale="1" volume="100" pan="0" rotation="1" draggable="true" costume="0" color="80,80,80,1" pen="tip" id="643"><costumes><list struct="atomic" id="644"></list></costumes><sounds><list struct="atomic" id="645"></list></sounds><blocks></blocks><variables></variables><scripts><script x="17.333333333333343" y="10"><block s="doSetVar"><l>employee database</l><block s="reportNewList"><list><custom-block s="employee, name: %s job title: %s salary: %s"><l>Ben Bitdiddle</l><l>computer wizard</l><l>60000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Alyssa P Hacker</l><l>computer programmer</l><l>40000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Cy D Fect</l><l>computer programmer</l><l>35000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Lem E Tweakit</l><l>computer technician</l><l>25000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Louis Reasoner</l><l>computer programmer trainee</l><l>30000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Oliver Warbucks</l><l>big wheel</l><l>650000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Eben Scrooge</l><l>chief accountant</l><l>75000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Robert Cratchet</l><l>accounting scrivener</l><l>18000</l></custom-block><custom-block s="employee, name: %s job title: %s salary: %s"><l>Aull DeWitt</l><l>secretary</l><l>25000</l></custom-block></list></block></block></script><script x="17.333333333333343" y="235.33333333333326"><custom-block s="name from employee %l"><l/></custom-block></script><script x="17.333333333333343" y="261.33333333333337"><custom-block s="job title from employee %l"><l/></custom-block></script><script x="17.333333333333343" y="287.33333333333337"><custom-block s="salary from employee %l"><l/></custom-block></script><script x="17" y="323.4000000000001"><block s="doSetVar"><l>salary &gt;100,000</l><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block></block></script><script x="20" y="439.0666666666668"><block s="doSetVar"><l>salary &lt;100,000</l><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block></block></script><script x="14" y="560.0666666666667"><block s="doReport"><block s="reportNewList"><list><block s="reportCombine"><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block><block s="reifyReporter"><autolambda><block s="reportVariadicSum"><list><l></l><l></l></list></block></autolambda><list></list></block></block><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block></list></block></block></script><script x="12" y="796.2333333333336"><block s="doReport"><block s="reportNewList"><list><block s="reportCombine"><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block><block s="reifyReporter"><autolambda><block s="reportVariadicSum"><list><l></l><l></l></list></block></autolambda><list></list></block></block><block s="reportListAttribute"><l><option>length</option></l><block var="salary &gt;100,000"/></block></list></block></block></script><script x="10" y="976.3999999999994"><block s="doReport"><block s="reportNewList"><list><custom-block s="map %repRing over %mult%l"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><list><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100,000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></list></custom-block></list></block></block></script></scripts></sprite><watcher var="employee database" style="normal" x="10" y="10" color="243,118,29" extX="80" extY="70"/><watcher var="salary &lt;100,000" style="normal" x="10" y="301.00000199999994" color="243,118,29" extX="80" extY="70"/><watcher var="salary &gt;100,000" style="normal" x="10" y="322.00000399999993" color="243,118,29" extX="80" extY="70"/><watcher var="total salary" style="normal" x="10" y="338.99999799999995" color="243,118,29" hidden="true"/></sprites></stage><variables><variable name="employee database"><list struct="atomic" id="928"></list></variable><variable name="salary &lt;100,000"><list struct="atomic" id="929"></list></variable><variable name="salary &gt;100,000"><list struct="atomic" id="930"></list></variable><variable name="total salary"><l>0</l></variable></variables></scene></scenes></project><media name="2021 - U3L11-Employee-Database" app="Snap! 11.0.8, https://snap.berkeley.edu" version="2"></media></snapdata>