<snapdata remixID="14894196"><project name="U3L2-Employee-Database" app="Snap! 11.0.8, https://snap.berkeley.edu" version="2"><notes></notes><thumbnail>data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKAAAAB4CAYAAAB1ovlvAAAQAElEQVR4AeydCYwWRRbH3xtX3AUElYBXVMCDTdQYBY3ueowgUXfVjFcwGnVMjGtcNG484xUT7yMaFdforgquxrhexPtalVUji6LrgcYjERBvMYBci4o7v5q8sbu/7o+Z7+seeqYf4X2v6tWrV1Wv/l99/bqqe1p+9n/ugbXogRbxf+6BtegBB+BadL43LZIKwI8++kieeOIJefzxxyvLX3jhBVm4cKFjpGAP1ADwnnvukfXWW0922GEH2XHHHbuoavmtt95ali1bJvfdd1/BU1Bt8zEAfvjhh7LnnntKxzVpoNWrV8tPP/0kcCPyRx11VGo59SiHQ9S5++67Q33ygwcPDvaWLl0qw4cPDzZMH110LE8aMjlpqLfzu+++e+hntWFS3OhrAGhNnXHGGTJ69GjZa6+95Oijj5YzzzwzcEC6zjrrBKA+99xzMnXqVDn22GNl1KhRYdWkzkUXXRTMbLTRRqKqwc4GG2wg1KOc9IABA+Sbb74JZcOGDQt80qRJgbe0tIT6hX70wDj97IG6q/bAA7GZZoUxuvbaa8PK9eabb8pDDz0k5LE7ceJEuf/+++Wll16SE088UY4//niZMWOGfPHFF/L999/LkiVL5M477wyrxqBBg+Sss84KdtZff30ZOnRoSG+yySahfPvttw95gMnKNn369JC3VRAZ/UlyZFBSbnnKIMsnOWVQUm55yiDLM26nYjwQA6A1gfNJf/LJJ8LP5YoVK8gK14fz5s0Ty1OuqoJs5cqVQv7bb78NeSrMnz9fPv300yAnTfncuXND+YIFC+TLL7+UuR1549glb+1jI43Wdnlan1zWmAdiAGRi7Vs/eOBvpGXm7bLOq3+XX1WEL5n5zzDeoX/dO6zE5o/GXOu1uuOBGACjFT6f/4n8uNsJsqoitHLc8bJydKv87f0WGdCiUVd4ukAPxADINx5iFYy2uffee0eza0y/++67a9TpjgLBz7bbbtsd1TXqfPXVV1LP1oYbbhhsvP3224GbH+BB4B+FeCAGwKwWCDCef/75rOKY/J133hEmOyYsQWbOnDnCDfasrqh2rnqqnTxLrx/ISzWEGAD5trP6wZO9HD9+fFKUmn/11VdlwoQJsnz58tTynghV8wMDN9LrrYDJfpkf4Mkyz+fngRgAs8zWWzmSdU466aQgGjhwYODNfBB196Ttem2NGDGi7gpYr66XFeeBGABZ+YyymuRaKQ/iJnUedrCRhy3GzZijnNWPPESZU/4eiAHQzNdzOJOdB7HbkYcdbORhS7Xz5161k5svnBfrgRgAAZ5966PNRq+dZs+eHXY/rJw6liZYOfTQQy0bdjssc9VVV4XkqaeeKo8++mgos7pRTtqICqRff/31oG95uBHlkOWjHPnnn38ebqbTPu3uu+++Qh/b29sDj+pH0+YHeFTu6Xw9EANglumHH344VnTEEUeEPV5Wnscee0xOO+20rnI275lodlBUNWzRtbW1hXK27UKi4+P8888Pp00AraoGUGLrjTfekPYOcMABDWlVDfvI5FVV+HfBBRcIRPkDDzyAKEbWPlE5hyDYeRk3blzYr6aPhx12WNgajFXyTK97IAZAVgwo+a0ngrSejR07Vg4++OCwIqFH+sYbbwzFm266qZxzzjmhnElHiIw9XuTTpk2Tm266KZRffvnlgg7l6GEHwj55uNUhTVvkKYMuvfRSgbB55JFHIooRthHsv//+sNAubdE+dg455BDhIEUo7Phg3B0sjMs4bSKHkDnl74EYAPM335hFQNVYzcZrqXaurKqdvHFLXrMnHogBkG+6fet7YqQ/6pof4P1xfGUZUwyAWZ0CmMmyNFkjOsk6ReStr8ZpI5om77R2PBADIJNiFO2OqsrXX38dRESxRMLtHYECF/qkCUYIMJCRJrAIyh0fra2tHZ8iRKNEswQSW221ldx2222CLoVwAheu20hjCx10SY8cOTKmSx10aZ+o9rzzzkNUQxdeeKHQP1UV+s2xLzh2CXjor1WyccORwVn94OSdivFADIDWRNLp7O2yk0A5k81JaFWVgw46SAgQFi1aJFOnThX44sWLBaChq6ry4osvkgxRs6rKe++9J62trTJmzBghMr3rrrvCMX2U7r33XnnttdfCecFTTjkl6GKPKBeODqCAA3IAxcNDl112GaIaItjYbLPNwkHZLbbYIvSLgxIzZ86UqE0qqmpXH8k79Y4HYgAEeEwwPNr8xhtv3JUlkmRiAZyqBvmQIUPC5E2fPl04+Uw0GwoiH9QDrNM6ImFon332EcBx3HHHhbrUgdBhxaMN9LDJ7RPsRsyFdrbZZpsgUu3sR8hEPlglaZe6Z599doi+ASy3lbANj6jHkuYHeKygoYxXyvJADIBZSlH5d999J0YPPvhgV9pk3eVMbJbudddd1yO79WxltZGUR8fo6d7zQAyArHxGWV1g6ysP4lovDzvYyMMW42bMUQ6wLU+ZU/4eiAHQzCedHt2KMx0LDiwPBwgEBaS5ziNPulkikGjEhrUP54EpAhuCnSuvvFLa29vDNaHZVe38GVft5CZ3XqwHYgAEeGnf+l133bWmF1xD8QAR+6q2FffZZ5/JI488EtNt7Qg4mHAAy6RHCwHW008/HUQAw4g6RKoQ9VAAQJSThoiAP/74Y5KZBOAIVhgTwRPBxzPPPBOuOQ8//HDJCl4wSJ0sf1DulI8HYgDMMklkmiwDGDwLzCObthW3+eabh9sd6I4cOTI82MPzxUw+T8VxCyQKQoDNVhkrFHUgAhOA89RTT8ktt9wSHvMkYOGRTsqNeLQTIo99eJJ4Wo8gBPtXXHGF7LHHHkJ76HH9yn40aae154EaAPKth6JdSjsUygrIY5aqv/xksWoQHVPXOJEtcqJPIlyTo4PcOHoQOthGnxWWSJXVDl3K0YeQEeWSZl8ZniTqIIOjiz1uHRFh0w+ia8ohG3OUk4Yod2rMA2uqFQOgOdt4WuVk9NhoHlA0WjdZLw9bqp1fJNVOztjr+YFyp+Y9UANAJrOe44k68yB+FvOwg408bCVdaX4wniz3fD4eiAEwyySv17AyAgfSBlI4hCwaJJDnOpGyKCEnT1ABt7xxZEYmY2cFmeXhUJoMeZSsHQIa+keUTuDEtSg8quvp3vdADIBMqFG0K+xGsIVlMnR4nwtgVNUQVVpZkrPneuuttwrc6sDR4/VnRKmqPT+QyjUgdoiiVRVzNbTzzjuHHRNVDdt+XPNxtjHtQCpjwkCUk4aQOxXjgRgArYmk0wlCmDjKCRJUNUS4pJEZRYMEZAQTyE4++eSwDcbPGXXgbI8RGBClooseRDl5OMECNkhThzxlEHWRWVSLLEm8WMlkHESlLTh2kgdSeesXutHVPukHyp3y9UAMgDicSYXn20zPrAG6ntVoXpvAhtewcUACa+YHOHmnYjwQA2AxTawlq95sn/BADQBZ/aBo75P5aFlaGn0oraw3ZdaHJKcPJiOdRpQbpZW7LB8PxACIwzFrnDS03XbbwQIReJDg1ofpcdiUiJfIkjICCyJOtuWQsytCFEodyuFEp3DLo891HTLqsBtCHdLUR266cHQJRIhqs3ZC0KO/qhp2aDg/yG4MdgmKrL/opZGNL63MZfl4oAaAXPMkHc8Fur3rhTKIt5gyoaTpCjsLdmhUVeWOO+4QjlUhZ6uOd8ZQh6gVTh2ut4o8kEobbOEB9jUdSEU3SuYHeFTu6Xw9EANglmlVFXvXC7cyVDXceiGqVNVwsFRVhW0zbCDn1g2noVVViDjJq2rYi1XVcHuEfd8iD6SqqnBolYi7pwdSGYdT8R6IAZDVzCiraaLFPIiVJcsOK2dWWZq8nq00/TQZqyTE+Bk73Ii8UzEeiAHQmsDxlk5ytr7yIK7p8rCDjTxssUpCqto15Hp+6FIqX6JP9SgGQBzOagKPjiJ6IJWzfexAEHhkXcRz4U99AgvO9pGGCBrgSSLQQEZwAE8SdpKyLFumByhJwxkPQQv9oi36zfYeAQzjQC9J5gfqQslyz+fjgRgA00zifHZC7LHMyZMnh6fY2EZDH9AwsaaHjJ0LZLfffrtccskl4XUXURCR5ucOXYhze9ghDbCoSyTd1tYWXoTEE2wAhzrUpS0CIPSzCADRb/jVV18d3shPMMR7bewwKn964phjjskyEeS0FRL+UYgHagCIwyFrTVXDu5Xtscybb745vCiIFQWd/fbbLzyayaqo+svPF5PMgVL2YylDF2JFIpDBDnmId/xxAJU0T9jBCWQ4QApgIKJZiLKoPfJpRDus3HC23ji8ysltwGyHUfnjO7wEM60+PjBKK3dZPh6IARCHp5llJTE5k8ltFADCLRZWO8pYaYg4SUMc/kQHoFLGPq+lkZ977rmoBSJ65gAqttE1m+SpB7F6UUYaHm0rGEl8oIPIOCsrdtnmo998CWiTSBy9NMryR5quyxrzQA0AmTAoy1xaBNmIjDYaqZdWJw9b/LxDBjpskjae5Q+XN+eBGAC7Y4qoMw/ipzEPO9jIwxYRMKT6y2VEd/zhOs15oAaAfOuhLLMECJS1t7eH4MJ04ciNrJw8ZZCl4RAyfhrh5I0IOEibPMotTTmUzCNLEjoEOQQwRL4cRKV/8KSu5aljZDLn+XsgBkAcntZE9IyclaPLhBIQjBo1Krzt1MCJDu+JUe18Q6qqhp0TtuFUNUS2PMJpkbRq54FUVe16CZF0/GNFog1VFQCkquFga1tbW3jzKmXYwFaHes3/9o4vCULVNR9IRS9JjDEp83y+HqgBIE7nuifazDXXXNOV5UKeDBfzbLGhy9NxBBhWRjlbb3ACDjgUPTzKM73UgSgjuLC2sY2M1RE5aQISOHlsY5c09XkclLIkEWyYjIOo1IFji75Hy03POOOiP5DJnOfvgRgAMd8bDgdgPOtLe2Wn3vBH2X1QZP9SAVhlp6+77rrB3/jAKAj8oxAPxACIw9NaicpJQ6YXTZvMOGWQ5dcWtz4Ypx/RNHkeWOfGNX9mTETF//WOB2oAyMRw/ZPVPIEGxB4qQQKRJJFla2treBspB0lVOyeQAEFVhaCBaz5ul6h2BhQzZswIAQdbbsi53uN6DjscZCXA4PAoMuryV9oJRNCFY5M+kuf+HekkYQO7ELbYvoNTP3kg9YMPPggvzWRbUOTn8NAVfsAfUNJ2PO+5Rj0QAyC7AlnOtr1gVZUpU6YIp5DZSeAQ6pZbbikHHnig7LLLLsILgHgPCx1iuw0wsYXG9tesWbOEvWQOp/KuGOpyKICdleuvv144PwiAOY41Z86c8F4YQIMe9rHJe2qoz04LeeryN0VIpxHAAsT1DqSiwxtb4bQvkRUQf5x++ulhu5H+if/L1QMxAPIzhMOht2bPkkGzpwYa/MY0GfXpEyE9Zr1FMuXMYwP99teL5dGbLpCbzzpO/vzHcbJszvOy/sL3ZPJBu8rSd/8VZONHD+oqR/+KP7XJ3ZeeKidM2EF03izZd9TAUO8vFmKrjwAAAvRJREFUh/5OKMfWY1MuDDZIy9z/CG3CaYP0UePHyjVnnBDaoM0J2w4JadqMErbRR+eUP4wNbdHff1wyOfQJvvz9F2XzHxaI8QFfvhUcjA8gVnFWQr5kN9xwQ/jrSpMmTZKJEycGPf9ozgMtyerskfITO2LkGPnvkN/LW0P37CLyr3z2oxi9vOCHrjSynuRfnv8/6Yl+1P6GY3aT1SN+21UfW9Fy0lB37L/U0Q904ej/e+4KeWX8beHPzT755JPCIwNJH61atSop8nyDHqgB4LBhw8LPK/fsDjjggHCEnjRUpTzXtvPmzetyK5cCHJowevbZZ7vKPNG4B2oA2Lip/lVz+PDhstNOO4XnXAAd1539a4TlGE1LObpRvl7wloSLL764fB0rWY+a7Y4DsFkPev2mPOAAbMp9XrlZDzgAm/Wg12/KAw7AptznlZv1gAOwWQ96/aY84ABsyn1euVkP9F0ANjtyr18KDzgASzEN1e2EA7C6c1+KkTsASzEN1e2EA7C6c1+KkTsASzEN1e2EA7DvzX2/6rEDsF9NZ98bjAOw781Zv+qxA7BfTWffG4wDsO/NWb/qsQOwX01n3xuMA7DvzVm/6nGPANivRu6DKYUHHIClmIbqdsIBWN25L8XIHYClmIbqdsIBWN25L8XIHYClmIbqdsIB2K25d6WiPOAALMqzbrdbHnAAdstNrlSUBxyARXnW7XbLAw7AbrnJlYrygAOwKM+63W55wAHYLTdVV6nokTsAi/aw26/rAQdgXfd4YdEecAAW7WG3X9cDDsC67vHCoj3gACzaw26/rgccgHXd44VFe6C8ACx65G6/FB5wAJZiGqrbCQdgdee+FCN3AJZiGqrbCQdgdee+FCN3AJZiGqrbCQdg+ea+Uj1yAFZquss3WAdg+eakUj1yAFZquss3WAdg+eakUj1yAFZquss3WAdg+eakUj2KAbBSI/fBlsIDDsBSTEN1O+EArO7cl2LkDsBSTEN1O+EArO7cl2Lk/wcAAP//NjHpSwAAAAZJREFUAwCXakB/43bfLQAAAABJRU5ErkJggg==</thumbnail><scenes select="1"><scene name="U3L2-Employee-Database"><notes></notes><hidden></hidden><headers></headers><code></code><blocks><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="Employees More than 100k" type="reporter" category="other"><header></header><code></code><translations></translations><inputs></inputs><script><block s="doDeclareVariables"><list><l>lessthan100k</l><l>morethan100k</l></list></block><block s="doSetVar"><l>lessthan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>morethan100k</l><block s="reportNewList"><list></list></block></block><block s="doForEach"><l>item</l><block var="employee database"/><script><block s="doIfElse"><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><block var="item"/></custom-block><l>100000</l></list></block><script><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="morethan100k"/></block></script><script><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="lessthan100k"/></block></script></block></script></block><block s="doReport"><block var="morethan100k"/></block></script></block-definition><block-definition s="Employees Less than 100k" type="reporter" category="other"><header></header><code></code><translations></translations><inputs></inputs><script><block s="doDeclareVariables"><list><l>lessthan100k</l><l>morethan100k</l></list></block><block s="doSetVar"><l>lessthan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>morethan100k</l><block s="reportNewList"><list></list></block></block><block s="doForEach"><l>item</l><block var="employee database"/><script><block s="doIfElse"><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><block var="item"/></custom-block><l>100000</l></list></block><script><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="morethan100k"/></block></script><script><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="lessthan100k"/></block></script></block></script></block><block s="doReport"><block var="lessthan100k"/></block></script></block-definition><block-definition s="Total number Earing more than 100k" type="reporter" category="other"><header></header><code></code><translations></translations><inputs></inputs><script><block s="doDeclareVariables"><list><l>lessthan100k</l><l>morethan100k</l></list></block><block s="doDeclareVariables"><list><l>TotalLess100k</l><l>TotalMore100k</l></list></block><block s="doSetVar"><l>lessthan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>morethan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>TotalMore100k</l><l>0</l></block><block s="doSetVar"><l>TotalLess100k</l><l>0</l></block><block s="doForEach"><l>item</l><block var="employee database"/><script><block s="doIfElse"><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><block var="item"/></custom-block><l>100000</l></list></block><script><block s="doChangeVar"><l>TotalMore100k</l><l>1</l></block><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="morethan100k"/></block></script><script><block s="doChangeVar"><l>TotalLess100k</l><l>1</l></block><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="lessthan100k"/></block></script></block></script></block><block s="doReport"><block var="TotalMore100k"/></block></script></block-definition><block-definition s="Total numbr earning less than 100k" type="reporter" category="other"><header></header><code></code><translations></translations><inputs></inputs><script><block s="doDeclareVariables"><list><l>lessthan100k</l><l>morethan100k</l></list></block><block s="doDeclareVariables"><list><l>TotalLess100k</l><l>TotalMore100k</l></list></block><block s="doSetVar"><l>lessthan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>morethan100k</l><block s="reportNewList"><list></list></block></block><block s="doSetVar"><l>TotalMore100k</l><l>0</l></block><block s="doSetVar"><l>TotalLess100k</l><l>0</l></block><block s="doForEach"><l>item</l><block var="employee database"/><script><block s="doIfElse"><block s="reportVariadicGreaterThan"><list><custom-block s="salary from employee %l"><block var="item"/></custom-block><l>100000</l></list></block><script><block s="doChangeVar"><l>TotalMore100k</l><l>1</l></block><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="morethan100k"/></block></script><script><block s="doChangeVar"><l>TotalLess100k</l><l>1</l></block><block s="doAddToList"><custom-block s="name from employee %l"><block var="item"/></custom-block><block var="lessthan100k"/></block></script></block></script></block><block s="doReport"><block var="TotalLess100k"/></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="267"><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="268"></list></costumes><sounds><list struct="atomic" id="269"></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="274"><costumes><list struct="atomic" id="275"></list></costumes><sounds><list struct="atomic" id="276"></list></sounds><blocks></blocks><variables></variables><scripts><script x="10" 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="10" y="261.33333333333337"><custom-block s="job title from employee %l"><l/></custom-block></script><script x="59.66666666666666" y="379.8333333333333"><custom-block s="Employees More than 100k"></custom-block></script><script x="245.66666666666666" y="388.8333333333333"><custom-block s="Employees Less than 100k"></custom-block></script><script x="797.8194010416665" y="358.26666666666625"><block var="TotalMore100k"/></script><script x="553.6666666666666" y="146.66666666666646"><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></script><script x="564.6666666666666" y="282.66666666666646"><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></block></script><script x="217.66666666666666" y="361.99999999999994"><custom-block s="Total number Earing more than 100k"></custom-block></script><script x="59.66666666666666" y="446.3333333333334"><block s="reportCONS"><block s="reportCombine"><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></block><block s="reifyReporter"><autolambda><block s="reportVariadicSum"><list><l></l><l></l></list></block></autolambda><list></list></block></block><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="name from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></block></block></script><script x="295.66666666666663" y="367.83333333333326"><custom-block s="Total numbr earning less than 100k"></custom-block></script><script x="796.6666666666666" y="416.16666666666674"><block s="reportCONS"><block s="reportCombine"><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><l>100000</l><custom-block s="salary from employee %l"><l/></custom-block></list></block></autolambda><list></list></block><block var="employee database"/></block></block><block s="reifyReporter"><autolambda><block s="reportVariadicSum"><list><l></l><l></l></list></block></autolambda><list></list></block></block><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="name from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><l>100000</l><custom-block s="salary from employee %l"><l/></custom-block></list></block></autolambda><list></list></block><block var="employee database"/></block></block></block></script><script x="553.6666666666666" y="642.8333333333335"><block s="reportQuotient"><block s="reportCombine"><block s="reportMap"><block s="reifyReporter"><autolambda><custom-block s="salary from employee %l"><l/></custom-block></autolambda><list></list></block><block s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></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 s="reportKeep"><block s="reifyPredicate"><autolambda><block s="reportVariadicLessThan"><list><custom-block s="salary from employee %l"><l/></custom-block><l>100000</l></list></block></autolambda><list></list></block><block var="employee database"/></block></block></block></script></scripts></sprite><watcher var="employee database" style="normal" x="10" y="10" color="243,118,29" extX="185.5615234375" extY="150"/></sprites></stage><variables><variable name="employee database"><list id="570"><item><list struct="atomic" id="571">Ben Bitdiddle,computer wizard,60000</list></item><item><list struct="atomic" id="572">Alyssa P Hacker,computer programmer,40000</list></item><item><list struct="atomic" id="573">Cy D Fect,computer programmer,35000</list></item><item><list struct="atomic" id="574">Lem E Tweakit,computer technician,25000</list></item><item><list struct="atomic" id="575">Louis Reasoner,computer programmer trainee,30000</list></item><item><list struct="atomic" id="576">Oliver Warbucks,big wheel,650000</list></item><item><list struct="atomic" id="577">Eben Scrooge,chief accountant,75000</list></item><item><list struct="atomic" id="578">Robert Cratchet,accounting scrivener,18000</list></item><item><list struct="atomic" id="579">Aull DeWitt,secretary,25000</list></item></list></variable></variables></scene></scenes></project><media name="U3L2-Employee-Database" app="Snap! 11.0.8, https://snap.berkeley.edu" version="2"></media></snapdata>