{"type":"excalidraw","version":2,"source":"https://AwesomeSystemDesign.dev","elements":[{"angle":0,"strokeColor":"#628572","backgroundColor":"#edf5ee","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-1"}],"updated":0,"link":null,"locked":false,"id":"shape-0","type":"rectangle","seed":41,"x":30,"y":30,"width":682.86244,"height":199.8,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-1","type":"text","seed":114,"x":50,"y":48,"width":642.86244,"height":163.8,"fontSize":18,"fontFamily":1,"text":"SELECT driver_id, ST_Distance(location, ST_Point(-73.98, 40.74))\nFROM drivers\nWHERE status = 'available'\nAND ride_type = 'uberx'\nAND ST_DWithin(location, ST_Point(-73.98, 40.74), 5000)\nORDER BY ST_Distance(location, ST_Point(-73.98, 40.74))\nLIMIT 10;","originalText":"SELECT driver_id, ST_Distance(location, ST_Point(-73.98, 40.74))\nFROM drivers\nWHERE status = 'available'\nAND ride_type = 'uberx'\nAND ST_DWithin(location, ST_Point(-73.98, 40.74), 5000)\nORDER BY ST_Distance(location, ST_Point(-73.98, 40.74))\nLIMIT 10;","textAlign":"left","verticalAlign":"middle","containerId":"shape-0","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#a68a53","backgroundColor":"#fff7e6","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-3"}],"updated":0,"link":null,"locked":false,"id":"shape-2","type":"rectangle","seed":187,"x":30,"y":254.8,"width":478.00048,"height":68,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-3","type":"text","seed":260,"x":50,"y":277.1,"width":438.00048,"height":23.400000000000002,"fontSize":18,"fontFamily":1,"text":"Uses R-tree / GiST index on POINT geometry","originalText":"Uses R-tree / GiST index on POINT geometry","textAlign":"left","verticalAlign":"middle","containerId":"shape-2","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":2}}],"appState":{"viewBackgroundColor":"#fbfbf8","gridSize":null},"files":{}}