SelectionProjection.excalidraw
⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠
Text Elements
Products
1 Coke 0
2 Tea 0
3 Apple 1
4 Banana 1
1 Coke 0
2 Tea 0
Selection (=Filtering) (WHERE)
Result
Coke
Tea
Projection (SELECT)
%%
Drawing
{ "type": "excalidraw", "version": 2, "source": "https://github.com/zsviczian/obsidian-excalidraw-plugin/releases/tag/1.9.19", "elements": [ { "id": "5rkmU5NmD159zZR7wJUyv", "type": "rectangle", "x": -234.14241960249282, "y": -247.98250320685554, "width": 307.8660897467606, "height": 103.49117469098793, "angle": 0, "strokeColor": "transparent", "backgroundColor": "#b2f2bb", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 457728831, "version": 194, "versionNonce": 940499903, "isDeleted": false, "boundElements": null, "updated": 1700684327278, "link": null, "locked": false }, { "type": "rectangle", "version": 142, "versionNonce": 577357137, "isDeleted": false, "id": "M3sfkVdhr2e5wacpi-Zvf", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": -237.9765625, "y": -258.34765625, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 320.6015625, "height": 218.8481297348485, "seed": 143783199, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "boundElements": [ { "id": "HKxoctt3y6kWm1wQ-K1LX", "type": "arrow" } ], "updated": 1700684116829, "link": null, "locked": false }, { "type": "text", "version": 9, "versionNonce": 2064249809, "isDeleted": false, "id": "qPJccJZ7", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": -152.859375, "y": -291.171875, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 87.83990478515625, "height": 25, "seed": 1733363871, "groupIds": [], "frameId": null, "roundness": null, "boundElements": [], "updated": 1700683916104, "link": null, "locked": false, "fontSize": 20, "fontFamily": 1, "text": "Products", "rawText": "Products", "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "Products", "lineHeight": 1.25, "baseline": 18 }, { "type": "text", "version": 68, "versionNonce": 2031279025, "isDeleted": false, "id": "jgNYPgRA", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": -213.203125, "y": -233.92578125, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 228.35995483398438, "height": 175, "seed": 173972959, "groupIds": [], "frameId": null, "roundness": null, "boundElements": [], "updated": 1700684102883, "link": null, "locked": false, "fontSize": 20, "fontFamily": 1, "text": "1 Coke 0\n\n2 Tea 0\n\n3 Apple 1\n\n4 Banana 1", "rawText": "1 Coke 0\n\n2 Tea 0\n\n3 Apple 1\n\n4 Banana 1", "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "1 Coke 0\n\n2 Tea 0\n\n3 Apple 1\n\n4 Banana 1", "lineHeight": 1.25, "baseline": 168 }, { "id": "K8jH2WN9fHLPWSwui_LDN", "type": "line", "x": -236.62701231060603, "y": -195.03385416666669, "width": 319.403409090909, "height": 0.10653409090912191, "angle": 0, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1469815423, "version": 108, "versionNonce": 1653816241, "isDeleted": false, "boundElements": null, "updated": 1700684040812, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 319.403409090909, 0.10653409090912191 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": null }, { "type": "line", "version": 213, "versionNonce": 524553087, "isDeleted": false, "id": "nFnze5OQTesYD67kVd5ds", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": -237.10356761364997, "y": -143.63787035523268, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 319.403409090909, "height": 0.10653409090912191, "seed": 1904185951, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "boundElements": [], "updated": 1700684054215, "link": null, "locked": false, "startBinding": null, "endBinding": null, "lastCommittedPoint": null, "startArrowhead": null, "endArrowhead": null, "points": [ [ 0, 0 ], [ 319.403409090909, 0.10653409090912191 ] ] }, { "type": "line", "version": 188, "versionNonce": 928915903, "isDeleted": false, "id": "mNjfapk17wKK_A8UyiF0i", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": -237.68832140152873, "y": -94.17527565826299, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 319.403409090909, "height": 0.10653409090912191, "seed": 1005090751, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "boundElements": [], "updated": 1700684059449, "link": null, "locked": false, "startBinding": null, "endBinding": null, "lastCommittedPoint": null, "startArrowhead": null, "endArrowhead": null, "points": [ [ 0, 0 ], [ 319.403409090909, 0.10653409090912191 ] ] }, { "type": "rectangle", "version": 458, "versionNonce": 544651007, "isDeleted": false, "id": "Fjztyd2cQQB2m2v7Mwc_j", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 325.83965038438674, "y": -212.38159946588684, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 320.6015625, "height": 115.76089707346411, "seed": 1453096287, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "boundElements": [ { "id": "HKxoctt3y6kWm1wQ-K1LX", "type": "arrow" }, { "id": "zhwLQn2bXn0TZ_loKf2iz", "type": "arrow" } ], "updated": 1700684234736, "link": null, "locked": false }, { "type": "text", "version": 335, "versionNonce": 1024942161, "isDeleted": false, "id": "xbJb3ZNL", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 350.10271148708745, "y": -187.70013647070874, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 228.35995483398438, "height": 75, "seed": 1534456223, "groupIds": [], "frameId": null, "roundness": null, "boundElements": [], "updated": 1700684148849, "link": null, "locked": false, "fontSize": 20, "fontFamily": 1, "text": "1 Coke 0\n\n2 Tea 0", "rawText": "1 Coke 0\n\n2 Tea 0", "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "1 Coke 0\n\n2 Tea 0", "lineHeight": 1.25, "baseline": 68 }, { "type": "line", "version": 376, "versionNonce": 1422470705, "isDeleted": false, "id": "TdNqndbfcdjiQ0RnlMd5a", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 326.67882417648144, "y": -148.80820938737548, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 319.403409090909, "height": 0.10653409090912191, "seed": 2082760127, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "boundElements": [], "updated": 1700684148849, "link": null, "locked": false, "startBinding": null, "endBinding": null, "lastCommittedPoint": null, "startArrowhead": null, "endArrowhead": null, "points": [ [ 0, 0 ], [ 319.403409090909, 0.10653409090912191 ] ] }, { "id": "HKxoctt3y6kWm1wQ-K1LX", "type": "arrow", "x": 87.28676149803603, "y": -146.07078857409093, "width": 229.59018244713457, "height": 0.27037406280953746, "angle": 0, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 767221759, "version": 532, "versionNonce": 1519398865, "isDeleted": false, "boundElements": [ { "type": "text", "id": "glE59Xuy" } ], "updated": 1700684155604, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 229.59018244713457, -0.27037406280953746 ] ], "lastCommittedPoint": null, "startBinding": { "elementId": "M3sfkVdhr2e5wacpi-Zvf", "gap": 4.6617614980360145, "focus": 0.026853676820311614 }, "endBinding": { "elementId": "Fjztyd2cQQB2m2v7Mwc_j", "gap": 8.962706439216106, "focus": -0.13708909066829625 }, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "glE59Xuy", "type": "text", "x": 150.5319030756072, "y": -183.7059756054957, "width": 103.09989929199219, "height": 75, "angle": 0, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1350778271, "version": 35, "versionNonce": 122163569, "isDeleted": false, "boundElements": null, "updated": 1700684177387, "link": null, "locked": false, "text": "Selection\n(=Filtering)\n(WHERE)", "rawText": "Selection\n(=Filtering)\n(WHERE)", "fontSize": 20, "fontFamily": 1, "textAlign": "center", "verticalAlign": "middle", "baseline": 68, "containerId": "HKxoctt3y6kWm1wQ-K1LX", "originalText": "Selection\n(=Filtering)\n(WHERE)", "lineHeight": 1.25 }, { "type": "rectangle", "version": 659, "versionNonce": 2051978545, "isDeleted": false, "id": "msTe71lI6NoUNKeMjIZ4u", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 867.0907152266268, "y": -213.5298757776149, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 131.73955533257936, "height": 115.76089707346411, "seed": 1759759647, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "boundElements": [ { "id": "zhwLQn2bXn0TZ_loKf2iz", "type": "arrow" } ], "updated": 1700684254767, "link": null, "locked": false }, { "type": "text", "version": 470, "versionNonce": 2081363665, "isDeleted": false, "id": "t7qAgK7z", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 887.7105540585833, "y": -252.7761476836027, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 63.279937744140625, "height": 25, "seed": 1716179263, "groupIds": [], "frameId": null, "roundness": null, "boundElements": [], "updated": 1700684254769, "link": null, "locked": false, "fontSize": 20, "fontFamily": 1, "text": "Result", "rawText": "Result", "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "Result", "lineHeight": 1.25, "baseline": 18 }, { "type": "text", "version": 479, "versionNonce": 2022053041, "isDeleted": false, "id": "cIYFue6e", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 891.3537763293275, "y": -188.8484127824368, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 44.63995361328125, "height": 75, "seed": 75256159, "groupIds": [], "frameId": null, "roundness": null, "boundElements": [], "updated": 1700684254769, "link": null, "locked": false, "fontSize": 20, "fontFamily": 1, "text": "Coke\n\nTea", "rawText": "Coke\n\nTea", "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "Coke\n\nTea", "lineHeight": 1.25, "baseline": 68 }, { "type": "line", "version": 578, "versionNonce": 757225105, "isDeleted": false, "id": "J61jrkizsKMIh2je8D03M", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 866.1232124471414, "y": -149.60127471214884, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "width": 132.47668936965556, "height": 0.8059906859228931, "seed": 1019792767, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "boundElements": [], "updated": 1700684254769, "link": null, "locked": false, "startBinding": null, "endBinding": null, "lastCommittedPoint": null, "startArrowhead": null, "endArrowhead": null, "points": [ [ 0, 0 ], [ 132.47668936965556, -0.8059906859228931 ] ] }, { "id": "zhwLQn2bXn0TZ_loKf2iz", "type": "arrow", "x": 657.1437612351278, "y": -152.20573287052724, "width": 204.73626368788098, "height": 0.4388430095462752, "angle": 0, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1826970577, "version": 115, "versionNonce": 68541681, "isDeleted": false, "boundElements": [ { "type": "text", "id": "jCVyN7vN" } ], "updated": 1700684254767, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 204.73626368788098, 0.4388430095462752 ] ], "lastCommittedPoint": null, "startBinding": { "elementId": "Fjztyd2cQQB2m2v7Mwc_j", "focus": 0.03364272057563093, "gap": 10.702548350741182 }, "endBinding": { "elementId": "msTe71lI6NoUNKeMjIZ4u", "focus": -0.06954121523963248, "gap": 5.210690303618094 }, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "jCVyN7vN", "type": "text", "x": 692.9516385478804, "y": -178.70880655477924, "width": 96.53990173339844, "height": 50, "angle": 0, "strokeColor": "#1e1e1e", "backgroundColor": "transparent", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1909440383, "version": 21, "versionNonce": 79127377, "isDeleted": false, "boundElements": null, "updated": 1700684247174, "link": null, "locked": false, "text": "Projection\n(SELECT)", "rawText": "Projection\n(SELECT)", "fontSize": 20, "fontFamily": 1, "textAlign": "center", "verticalAlign": "middle", "baseline": 43, "containerId": "zhwLQn2bXn0TZ_loKf2iz", "originalText": "Projection\n(SELECT)", "lineHeight": 1.25 }, { "type": "rectangle", "version": 330, "versionNonce": 1980140081, "isDeleted": false, "id": "yUCEp1LGbbWHQIG7Ju0q9", "fillStyle": "hachure", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "angle": 0, "x": 377.8710791806779, "y": -209.3757701680496, "strokeColor": "transparent", "backgroundColor": "#b2f2bb", "width": 116.41213754980362, "height": 112.75882427381487, "seed": 1814617489, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "boundElements": [], "updated": 1700684338226, "link": null, "locked": false } ], "appState": { "theme": "light", "viewBackgroundColor": "#ffffff", "currentItemStrokeColor": "transparent", "currentItemBackgroundColor": "#b2f2bb", "currentItemFillStyle": "hachure", "currentItemStrokeWidth": 1, "currentItemStrokeStyle": "solid", "currentItemRoughness": 1, "currentItemOpacity": 100, "currentItemFontFamily": 1, "currentItemFontSize": 20, "currentItemTextAlign": "left", "currentItemStartArrowhead": null, "currentItemEndArrowhead": "arrow", "scrollX": 358.7400125440254, "scrollY": 1032.0866675194154, "zoom": { "value": 0.537825147083261 }, "currentItemRoundness": "round", "gridSize": null, "gridColor": { "Bold": "#C9C9C9FF", "Regular": "#EDEDEDFF" }, "currentStrokeOptions": null, "previousGridSize": null, "frameRendering": { "enabled": true, "clip": true, "name": true, "outline": true } }, "files": {}}%%