{"id":6544,"date":"2024-03-06T07:47:00","date_gmt":"2024-03-06T07:47:00","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?post_type=web-story&#038;p=6544"},"modified":"2024-03-06T07:47:00","modified_gmt":"2024-03-06T07:47:00","slug":"master-your-queries-advanced-sql-tips-for-data-analysts","status":"publish","type":"web-story","link":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/","title":{"rendered":"Master Your Queries: Advanced SQL Tips for Data Analysts"},"content":{"rendered":"<p><html amp=\"\" lang=\"en\"><head><meta charSet=\"utf-8\"\/><meta name=\"viewport\" content=\"width=device-width,minimum-scale=1,initial-scale=1\"\/><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0.js\"><\/script><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0\/amp-story-1.0.js\" custom-element=\"amp-story\"><\/script><link href=\"https:\/\/fonts.googleapis.com\/css2?display=swap&amp;family=Karla%3Awght%40700&amp;family=Alegreya%3Awght%40700&amp;family=Roboto%3Awght%40700\" rel=\"stylesheet\"\/>\n<style amp-boilerplate=\"\">body{-webkit-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-moz-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-ms-animation:-amp-start 8s steps(1,end) 0s 1 normal both;animation:-amp-start 8s steps(1,end) 0s 1 normal both}@-webkit-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-moz-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-ms-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-o-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}<\/style>\n<p><noscript><\/p>\n<style amp-boilerplate=\"\">body{-webkit-animation:none;-moz-animation:none;-ms-animation:none;animation:none}<\/style>\n<p><\/noscript><\/p>\n<style amp-custom=\"\">\n              h1, h2, h3 { font-weight: normal; }<\/p>\n<p>              amp-story-page {\n                background-color: #131516;\n              }<\/p>\n<p>              amp-story-grid-layer {\n                overflow: visible;\n              }<\/p>\n<p>              @media (max-aspect-ratio: 9 \/ 16)  {\n                @media (min-aspect-ratio: 320 \/ 678) {\n                  amp-story-grid-layer.grid-layer {\n                    margin-top: calc((100% \/ 0.5625 - 100% \/ 0.6666666666666666) \/ 2);\n                  }\n                }\n              }<\/p>\n<p>              @media not all and (min-resolution:.001dpcm) {\n                @media {\n                  p.text-wrapper > span {\n                    font-size: calc(100% - 0.5px);\n                  }\n                }\n              }<\/p>\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area {\n                position: absolute;\n                overflow: hidden;\n                width: 100%;\n                left: 0;\n                height: calc(1.1851851851851851 * 100%);\n                top: calc((1 - 1.1851851851851851) * 100% \/ 2);\n              }<\/p>\n<p>              .element-overlay-area {\n                position: absolute;\n                width: 100%;\n                height: 100%;\n                top: 0;\n                left: 0;\n              }<\/p>\n<p>              .page-safe-area {\n                overflow: visible;\n                position: absolute;\n                top: 0;\n                bottom: 0;\n                left: 0;\n                right: 0;\n                width: 100%;\n                height: calc(0.84375 * 100%);\n                margin: auto 0;\n              }<\/p>\n<p>              .mask {\n                position: absolute;\n                overflow: hidden;\n              }<\/p>\n<p>              .fill {\n                position: absolute;\n                top: 0;\n                left: 0;\n                right: 0;\n                bottom: 0;\n                margin: 0;\n              }<\/p>\n<p>              @media (prefers-reduced-motion: no-preference) {\n                .animation-wrapper {\n                  opacity: var(--initial-opacity);\n                  transform: var(--initial-transform);\n                }\n              }<\/p>\n<p>              amp-story-grid-layer.align-bottom {\n                align-content: end;\n                padding: 0;\n                \/* \n                  AMP CTA Layer will exactly occupy 74px regardless of any device.\n                  To space out captions 74px from the BOTTOM (AMP CTA Layer),\n                  74px from the TOP should also be spaced out and thus: 2 * 74px\n                  will be the desired max-height.\n                *\/\n                max-height: calc(100vh - (2 * 74px));\n              }<\/p>\n<p>              .captions-area {\n                padding: 0 32px 0;\n              }<\/p>\n<p>              amp-story-captions {\n                margin-bottom: 16px;\n                text-align: center;\n              }\n              <\/style>\n<p><meta name=\"web-stories-replace-head-start\"\/><title>Master Your Queries: Advanced SQL Tips for Data Analysts<br \/>\n<\/title><link rel=\"canonical\" href=\"https:\/\/pickl.ai\/blog\/?post_type=web-story&amp;p=6544\"\/><meta name=\"web-stories-replace-head-end\"\/><\/head><body><amp-story standalone=\"\" publisher=\"Pickl.AI\" publisher-logo-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2022\/01\/cropped-cropped-favicon.png\" title=\"Master Your Queries: Advanced SQL Tips for Data Analysts\n\" poster-portrait-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg\"><amp-story-page id=\"b40e4283-0927-4331-ab53-ee960c21e33d\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#eee\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-3b504039-cb1f-41a3-9796-401e6fd8f83e\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.8932%;top:0;width:76.45631%;height:46.76375%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f05a1fc8-ad09-413d-b99e-f5c46458ed43\">\n<div style=\"position:absolute;width:100%;height:108.99655%;left:0%;top:-4.49827%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822.jpg\" alt=\"6470822\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 34vh, 76vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:16.01942%;top:54.04531%;width:72.3301%;height:40.7767%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6711409395973155% 0.6711409395973155% 0.6711409395973155% 0.6711409395973155% \/ 0.7936507936507936% 0.7936507936507936% 0.7936507936507936% 0.7936507936507936%\" id=\"el-9cd571a9-31ed-48f6-a802-781c1db60cb4\">\n<h1 id=\"master-your-queries-advanced-sql-tips-for-data-analysts\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.1479865771812077% 0;font-family:&quot;Karla&quot;,sans-serif;font-size:0.679612em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Master Your Queries: Advanced SQL Tips for Data Analysts<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"ec16c34a-0b57-4b48-b57d-86c6f63db136\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#b7efff\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-9ac99ef9-5aca-467b-a990-f4445af4bd83\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:19.41748%;top:41.90939%;width:66.74757%;height:15.53398%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7272727272727273% 0.7272727272727273% 0.7272727272727273% 0.7272727272727273% \/ 2.083333333333333% 2.083333333333333% 2.083333333333333% 2.083333333333333%\" id=\"el-7745bda7-1767-4d49-81ad-9786da4b5405\">\n<h3 id=\"conquer-complex-data-with-common-table-expressions-ctes\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.8083636363636373% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.420712em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #a4133c\">Conquer Complex Data with Common Table Expressions (CTEs)<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:21.60194%;top:62.78317%;width:64.56311%;height:25.88997%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7518796992481203% 0.7518796992481203% 0.7518796992481203% 0.7518796992481203% \/ 1.25% 1.25% 1.25% 1.25%\" id=\"el-288130ce-b195-4cde-9524-82b19c9318e2\">\n<h3 id=\"simplify-complex-queries-and-improve-readability-with-ctes-your-temporary-result-set-saviors\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.7868421052631586% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.420712em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Simplify complex queries and improve readability with CTEs, your temporary result set saviors.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:15.53398%;top:3.23625%;width:68.68932%;height:33.33333%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-0bc3d2be-6d07-43d4-bcae-627cd4ec4ee9\">\n<div style=\"position:absolute;width:109.16595%;height:100%;left:-4.58297%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-scaled.jpg\" alt=\"3561570\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-2048x1365.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-1536x1024.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-1024x683.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-900x600.jpg 900w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-768x512.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-300x200.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-150x100.jpg 150w\" sizes=\"(min-width: 1024px) 31vh, 69vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:31.06796%;top:94.01294%;width:43.68932%;height:5.01618%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.1111111111111112% 1.1111111111111112% 1.1111111111111112% 1.1111111111111112% \/ 6.451612903225806% 6.451612903225806% 6.451612903225806% 6.451612903225806%\" id=\"el-20dfbb19-397b-48fe-bcd1-a87cb957b943\"><a href=\"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-Tips.jpg\" data-tooltip-text=\"Advanced SQL Tips and Tricks for Data Analysts- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.2109374999999996% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #800f2f\">Learn More&nbsp;<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"301a4fe6-aded-453f-8a62-ea17b7ca4f35\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#ffffb7\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-341db796-326d-4f11-93db-2a0efd5920da\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:19.41748%;top:45.46926%;width:66.74757%;height:10.84142%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7272727272727273% 0.7272727272727273% 0.7272727272727273% 0.7272727272727273% \/ 2.9850746268656714% 2.9850746268656714% 2.9850746268656714% 2.9850746268656714%\" id=\"el-88c5816a-03fd-44ed-88a2-33d8513b923d\">\n<h3 id=\"unlock-insights-with-window-functions\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.8083636363636373% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.420712em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #003bad\">Unlock Insights with Window Functions<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:20.63107%;top:60.5178%;width:64.56311%;height:27.83172%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7518796992481203% 0.7518796992481203% 0.7518796992481203% 0.7518796992481203% \/ 1.1627906976744187% 1.1627906976744187% 1.1627906976744187% 1.1627906976744187%\" id=\"el-d1824fea-ed79-4b50-b015-b7b2b6886f05\">\n<h2 id=\"analyze-trends-compare-values-and-rank-data-dynamically-using-powerful-window-functions\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.817105263157895% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Analyze trends, compare values, and rank data dynamically using powerful window functions.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:31.06796%;top:94.33657%;width:43.68932%;height:5.01618%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.1111111111111112% 1.1111111111111112% 1.1111111111111112% 1.1111111111111112% \/ 6.451612903225806% 6.451612903225806% 6.451612903225806% 6.451612903225806%\" id=\"el-74724957-ef7e-4418-8b1e-0c8e63d25e65\"><a href=\"https:\/\/pickl.ai\/blog\/why-sql-is-important-for-data-analyst\/\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-2\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.2109374999999996% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #0044c9\">Learn More&nbsp;<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.62136%;top:0;width:74.27184%;height:38.02589%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f9f4e904-f149-4fe5-9d4d-5dd055f2ece9\">\n<div style=\"position:absolute;width:100%;height:130.21276%;left:0%;top:-15.10638%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-scaled.jpg\" alt=\"23246946_1907.i109.039.p.m004.c30.programming development isometric icons-16\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-2048x2048.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 33vh, 74vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"0cb86558-f2e1-46ec-adb8-ad7f7f5a8a67\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#b6c1f5\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-6cf969e9-f643-4cd1-9a89-85a0969b37de\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:18.20388%;top:49.67638%;width:67.96117%;height:12.45955%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7142857142857143% 0.7142857142857143% 0.7142857142857143% 0.7142857142857143% \/ 2.5974025974025974% 2.5974025974025974% 2.5974025974025974% 2.5974025974025974%\" id=\"el-5e864ad4-fe7a-4b3c-b619-4f3b5c004983\">\n<h2 id=\"level-up-calculations-with-subqueries\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.9160714285714291% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.485437em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #590d22\">Level Up Calculations with Subqueries<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:20.87379%;top:66.50485%;width:65.29126%;height:24.91909%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7434944237918215% 0.7434944237918215% 0.7434944237918215% 0.7434944237918215% \/ 1.2987012987012987% 1.2987012987012987% 1.2987012987012987% 1.2987012987012987%\" id=\"el-0dfefd0d-1494-46fa-a07b-1f7079eb31c3\">\n<h3 id=\"master-the-art-of-subqueries-to-filter-aggregate-and-manipulate-data-within-your-main-query\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.7481412639405203% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.404531em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Master the art of subqueries to filter, aggregate, and manipulate data within your main query.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:31.5534%;top:95.79288%;width:43.68932%;height:5.01618%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.1111111111111112% 1.1111111111111112% 1.1111111111111112% 1.1111111111111112% \/ 6.451612903225806% 6.451612903225806% 6.451612903225806% 6.451612903225806%\" id=\"el-3ce578ab-984d-43a2-b7d4-d8af00fd7fb8\"><a href=\"https:\/\/pickl.ai\/blog\/introduction-to-sql-for-data-science\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/01\/INTRODUCTION-TO-SQL.jpg\" data-tooltip-text=\"SQL for Data Science: Importance &amp; Application- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-3\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.2109374999999996% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #590d22\">Learn More&nbsp;<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.86408%;top:0;width:74.27184%;height:45.30744%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-cf427c8c-5a9c-468e-94a7-7e9729fa2df3\">\n<div style=\"position:absolute;width:100%;height:109.28572%;left:0%;top:-4.64286%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348.jpg\" alt=\"29765895_7559348\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 33vh, 74vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"9bfa9b37-35b8-4eaa-8ad7-a6c82fc8e79f\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#eee\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-5580426a-dd5e-4b29-b8a2-4a84cec28735\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:16.01942%;top:44.17476%;width:67.96117%;height:17.96117%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7142857142857143% 0.7142857142857143% 0.7142857142857143% 0.7142857142857143% \/ 1.8018018018018018% 1.8018018018018018% 1.8018018018018018% 1.8018018018018018%\" id=\"el-23a5a8fb-d783-4073-b7fe-0471a0f678b8\">\n<h2 id=\"optimize-performance-with-indexes\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.9160714285714291% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.485437em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #db4e16\">Optimize Performance with Indexes<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:23.78641%;top:66.50485%;width:58.98058%;height:24.91909%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.823045267489712% 0.823045267489712% 0.823045267489712% 0.823045267489712% \/ 1.2987012987012987% 1.2987012987012987% 1.2987012987012987% 1.2987012987012987%\" id=\"el-10862823-68c5-49a1-b67c-8c42e277e1e3\">\n<h3 id=\"speed-up-your-queries-by-strategically-creating-indexes-on-frequently-used-columns\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.8281893004115224% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.404531em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #131516\">Speed up your queries by strategically creating indexes on frequently used columns.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:31.5534%;top:95.79288%;width:43.68932%;height:5.01618%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.1111111111111112% 1.1111111111111112% 1.1111111111111112% 1.1111111111111112% \/ 6.451612903225806% 6.451612903225806% 6.451612903225806% 6.451612903225806%\" id=\"el-a5e344c8-ba70-4c32-88a2-c9f6fcc448aa\"><a href=\"https:\/\/pickl.ai\/blog\/differences-between-sql-and-t-sql-with-example\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/07\/SQL-vs.-T-SQL-2.jpg\" data-tooltip-text=\"Differences Between SQL and T-SQL [with Example]- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-4\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.2109374999999996% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #db5332\">Learn More&nbsp;<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:77.18447%;height:39.80583%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-ab6dedf0-2353-4738-af2d-7097bb4d99a8\">\n<div style=\"position:absolute;width:100%;height:129.26828%;left:0%;top:-14.63414%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532.jpg\" alt=\"29169204_7534532\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"12a6697d-0236-47fc-b973-e2878cd7b34d\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#eee\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-c6d1b1e4-0b26-461e-af82-723679518c75\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:16.26214%;top:37.54045%;width:67.96117%;height:12.45955%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7142857142857143% 0.7142857142857143% 0.7142857142857143% 0.7142857142857143% \/ 2.5974025974025974% 2.5974025974025974% 2.5974025974025974% 2.5974025974025974%\" id=\"el-83a85487-2ea3-44fe-bbc5-0ba3a4c99bb3\">\n<h2 id=\"embrace-the-power-of-dynamic-sql\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.9160714285714291% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.485437em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #db4e16\">Embrace the Power of Dynamic SQL<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:16.26214%;top:55.33981%;width:62.62136%;height:21.35922%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7751937984496124% 0.7751937984496124% 0.7751937984496124% 0.7751937984496124% \/ 1.5151515151515151% 1.5151515151515151% 1.5151515151515151% 1.5151515151515151%\" id=\"el-1b54aec1-b558-43b5-a27b-90e54cd2c141\">\n<h3 id=\"build-and-execute-sql-statements-on-the-fly-for-ultimate-flexibility-and-adaptability\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.8112403100775202% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.420712em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #131516\">Build and execute SQL statements on the fly for ultimate flexibility and adaptability.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:18.20388%;top:82.03883%;width:66.01942%;height:17.96117%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7352941176470588% 0.7352941176470588% 0.7352941176470588% 0.7352941176470588% \/ 1.8018018018018018% 1.8018018018018018% 1.8018018018018018% 1.8018018018018018%\" id=\"el-10868ab8-77a5-44ec-943a-cd288aadf39e\"><a href=\"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/\thttps:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/\" data-tooltip-text=\"\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h3 id=\"learn-more-about-advanced-sql-and-unlock-the-full-potential-of-your-data\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11891084558823489% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.372168em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #db5332\">Learn more about advanced SQL and unlock the full potential of your data!<\/span><\/span><\/h3>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.16505%;top:2.589%;width:77.18447%;height:29.61165%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-0f99bf55-91b5-4791-b19d-2070813ea0e0\">\n<div style=\"position:absolute;width:102.30607%;height:100%;left:-1.15304%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-scaled.jpg\" alt=\"sql text on wooden blocks, business concept, blue background\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-2048x1152.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-1536x864.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-1024x576.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-768x432.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-300x169.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-150x84.jpg 150w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><\/amp-story><\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"Looking to improve your SQL skills? Discover these advanced SQL tips and methods for data analysts. Read this blog to learn more.\n","protected":false},"author":1,"featured_media":6552,"template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"web_stories_publisher_logo":935,"web_stories_poster":[],"web_stories_products":[],"footnotes":""},"web_story_category":[],"web_story_tag":[],"class_list":["post-6544","web-story","type-web-story","status-publish","has-post-thumbnail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Master Your Queries: Advanced SQL Tips for Data Analysts - Pickl.AI<\/title>\n<meta name=\"description\" content=\"Looking to improve your SQL skills? Discover these advanced SQL tips and methods for data analysts. Read this blog to learn more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Master Your Queries: Advanced SQL Tips for Data Analysts\" \/>\n<meta property=\"og:description\" content=\"Looking to improve your SQL skills? Discover these advanced SQL tips and methods for data analysts. Read this blog to learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\"},\"headline\":\"Master Your Queries: Advanced SQL Tips for Data Analysts\",\"datePublished\":\"2024-03-06T07:47:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/\"},\"wordCount\":145,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-6470822.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/\",\"name\":\"Master Your Queries: Advanced SQL Tips for Data Analysts - Pickl.AI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-6470822.jpg\",\"datePublished\":\"2024-03-06T07:47:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-6470822.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-6470822.jpg\",\"width\":640,\"height\":853,\"caption\":\"6470822\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/master-your-queries-advanced-sql-tips-for-data-analysts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stories\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Master Your Queries: Advanced SQL Tips for Data Analysts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"sameAs\":[\"https:\\\/\\\/pickl.ai\\\/blog\"],\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/administrator\\\/transorgstandbyorangeironman\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Master Your Queries: Advanced SQL Tips for Data Analysts - Pickl.AI","description":"Looking to improve your SQL skills? Discover these advanced SQL tips and methods for data analysts. Read this blog to learn more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/","og_locale":"en_US","og_type":"article","og_title":"Master Your Queries: Advanced SQL Tips for Data Analysts","og_description":"Looking to improve your SQL skills? Discover these advanced SQL tips and methods for data analysts. Read this blog to learn more.","og_url":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/","og_site_name":"Pickl.AI","og_image":[{"width":640,"height":853,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/"},"author":{"name":"Admin","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab"},"headline":"Master Your Queries: Advanced SQL Tips for Data Analysts","datePublished":"2024-03-06T07:47:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/"},"wordCount":145,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/","url":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/","name":"Master Your Queries: Advanced SQL Tips for Data Analysts - Pickl.AI","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","datePublished":"2024-03-06T07:47:00+00:00","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","width":640,"height":853,"caption":"6470822"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/master-your-queries-advanced-sql-tips-for-data-analysts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Stories","item":"https:\/\/www.pickl.ai\/blog\/web-stories\/"},{"@type":"ListItem","position":3,"name":"Master Your Queries: Advanced SQL Tips for Data Analysts"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3","url":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","caption":"Admin"},"sameAs":["https:\/\/pickl.ai\/blog"],"url":"https:\/\/www.pickl.ai\/blog\/administrator\/transorgstandbyorangeironman\/"}]}},"story_data":{"version":47,"pages":[{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"3b504039-cb1f-41a3-9796-401e6fd8f83e"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"6470822-300x300.jpg","width":300,"height":300,"filesize":20634,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-300x300.jpg"},"large":{"file":"6470822-1024x1024.jpg","width":1024,"height":1024,"filesize":109345,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-1024x1024.jpg"},"thumbnail":{"file":"6470822-150x150.jpg","width":150,"height":150,"filesize":7541,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-150x150.jpg"},"medium_large":{"file":"6470822-768x768.jpg","width":768,"height":768,"filesize":74353,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-768x768.jpg"},"1536x1536":{"file":"6470822-1536x1536.jpg","width":1536,"height":1536,"filesize":182754,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-1536x1536.jpg"},"magine-hero":{"file":"6470822-1400x600.jpg","width":1400,"height":600,"filesize":94331,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-1400x600.jpg"},"magine-thumbnail":{"file":"6470822-900x600.jpg","width":900,"height":600,"filesize":76255,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-900x600.jpg"},"magine-vertical-thumbnail":{"file":"6470822-600x800.jpg","width":600,"height":800,"filesize":69700,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-600x800.jpg"},"web-stories-poster-portrait":{"file":"6470822-640x853.jpg","width":640,"height":853,"filesize":76300,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-640x853.jpg"},"web-stories-publisher-logo":{"file":"6470822-96x96.jpg","width":96,"height":96,"filesize":3923,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-96x96.jpg"},"web-stories-thumbnail":{"file":"6470822-150x150.jpg","width":150,"height":150,"filesize":7541,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822-150x150.jpg"},"full":{"file":"6470822.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#d4dfef","blurHash":"UFLYE9El-iM|RR}ln4$f5Ta#4=o}xo-QV^WC","creationDate":1709706161000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/6470822.jpg","id":6546,"alt":"6470822","local":false},"type":"image","x":49,"y":0,"width":315,"height":289,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"f05a1fc8-ad09-413d-b99e-f5c46458ed43"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Karla"},"fontSize":42,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Master Your Queries: Advanced SQL Tips for Data Analysts<\/span>","x":66,"y":334,"width":298,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":252,"id":"9cd571a9-31ed-48f6-a802-781c1db60cb4","marginOffset":0.8819999999999979}],"backgroundColor":{"color":{"r":238,"g":238,"b":238}},"id":"b40e4283-0927-4331-ab53-ee960c21e33d"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"9ac99ef9-5aca-467b-a990-f4445af4bd83","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":26,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #a4133c\">Conquer Complex Data with Common Table Expressions (CTEs)<\/span>","x":80,"y":259,"width":275,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":96,"id":"7745bda7-1767-4d49-81ad-9786da4b5405","marginOffset":0.5669999999999931,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":26,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Simplify complex queries and improve readability with CTEs, your temporary result set saviors.<\/span>","x":89,"y":388,"width":266,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":160,"id":"288130ce-b195-4cde-9524-82b19c9318e2","marginOffset":-4.347000000000001},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1707,"sizes":{"medium":{"file":"3561570-300x200.jpg","width":300,"height":200,"filesize":17987,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-300x200.jpg"},"large":{"file":"3561570-1024x683.jpg","width":1024,"height":683,"filesize":87234,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-1024x683.jpg"},"thumbnail":{"file":"3561570-150x150.jpg","width":150,"height":150,"filesize":8825,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-150x150.jpg"},"medium_large":{"file":"3561570-768x512.jpg","width":768,"height":512,"filesize":61186,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-768x512.jpg"},"1536x1536":{"file":"3561570-1536x1024.jpg","width":1536,"height":1024,"filesize":141990,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-1536x1024.jpg"},"2048x2048":{"file":"3561570-2048x1365.jpg","width":2048,"height":1365,"filesize":201289,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-2048x1365.jpg"},"magine-hero":{"file":"3561570-1400x600.jpg","width":1400,"height":600,"filesize":105650,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-1400x600.jpg"},"magine-thumbnail":{"file":"3561570-900x600.jpg","width":900,"height":600,"filesize":73801,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-900x600.jpg"},"magine-vertical-thumbnail":{"file":"3561570-600x800.jpg","width":600,"height":800,"filesize":58290,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-600x800.jpg"},"web-stories-poster-portrait":{"file":"3561570-640x853.jpg","width":640,"height":853,"filesize":62503,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-640x853.jpg"},"web-stories-publisher-logo":{"file":"3561570-96x96.jpg","width":96,"height":96,"filesize":4623,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-96x96.jpg"},"web-stories-thumbnail":{"file":"3561570-150x100.jpg","width":150,"height":100,"filesize":6993,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-150x100.jpg"},"full":{"file":"3561570-scaled.jpg","width":2560,"height":1707,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#c1cbb8","blurHash":"UOD.^FOtNzbtTLR*s8bJ7QNgNyaetQv}Rkad","creationDate":1709707681000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/3561570-scaled.jpg","id":6547,"alt":"3561570","local":false},"type":"image","x":64,"y":20,"width":283,"height":206,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"0bc3d2be-6d07-43d4-bcae-627cd4ec4ee9"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #800f2f\">Learn More&nbsp;<\/span>","x":128,"y":581,"width":180,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":31,"id":"20dfbb19-397b-48fe-bcd1-a87cb957b943","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-Tips.jpg","desc":"Advanced SQL Tips and Tricks for Data Analysts- Pickl.AI"}}],"backgroundColor":{"color":{"r":183,"g":239,"b":255}},"animations":[],"id":"ec16c34a-0b57-4b48-b57d-86c6f63db136"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"341db796-326d-4f11-93db-2a0efd5920da","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":26,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #003bad\">Unlock Insights with Window Functions<\/span>","x":80,"y":281,"width":275,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":67,"id":"88c5816a-03fd-44ed-88a2-33d8513b923d","marginOffset":0.5669999999999931,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Analyze trends, compare values, and rank data dynamically using powerful window functions.<\/span>","x":85,"y":374,"width":266,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":172,"id":"d1824fea-ed79-4b50-b015-b7b2b6886f05","marginOffset":-4.347000000000001,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #0044c9\">Learn More&nbsp;<\/span>","x":128,"y":583,"width":180,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":31,"id":"74724957-ef7e-4418-8b1e-0c8e63d25e65","type":"text","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/why-sql-is-important-for-data-analyst\/","rel":[],"type":"regular","pageId":null,"icon":null,"desc":null}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":2560,"sizes":{"medium":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-300x300.jpg","width":300,"height":300,"filesize":19544,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-300x300.jpg"},"large":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1024x1024.jpg","width":1024,"height":1024,"filesize":134099,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1024x1024.jpg"},"thumbnail":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-150x150.jpg","width":150,"height":150,"filesize":8253,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-150x150.jpg"},"medium_large":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-768x768.jpg","width":768,"height":768,"filesize":83669,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-768x768.jpg"},"1536x1536":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1536x1536.jpg","width":1536,"height":1536,"filesize":254000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1536x1536.jpg"},"2048x2048":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-2048x2048.jpg","width":2048,"height":2048,"filesize":388018,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-2048x2048.jpg"},"magine-hero":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1400x600.jpg","width":1400,"height":600,"filesize":172322,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-1400x600.jpg"},"magine-thumbnail":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-900x600.jpg","width":900,"height":600,"filesize":101727,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-900x600.jpg"},"magine-vertical-thumbnail":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-600x800.jpg","width":600,"height":800,"filesize":86182,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-600x800.jpg"},"web-stories-poster-portrait":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-640x853.jpg","width":640,"height":853,"filesize":96242,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-640x853.jpg"},"web-stories-publisher-logo":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-96x96.jpg","width":96,"height":96,"filesize":5464,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-96x96.jpg"},"web-stories-thumbnail":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-150x150.jpg","width":150,"height":150,"filesize":8253,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-150x150.jpg"},"full":{"file":"23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-scaled.jpg","width":2560,"height":2560,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#497687","blurHash":"UpPQKfR*?aadR*WBt7WB~Wj?D*WXt7s:Rjfk","creationDate":"2024-03-05T06:05:11","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/23246946_1907.i109.039.p.m004.c30.programming-development-isometric-icons-16-scaled.jpg","id":6517,"alt":"23246946_1907.i109.039.p.m004.c30.programming development isometric icons-16","local":false},"type":"image","x":52,"y":0,"width":306,"height":235,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"f9f4e904-f149-4fe5-9d4d-5dd055f2ece9"}],"backgroundColor":{"color":{"r":255,"g":255,"b":183}},"animations":[],"id":"301a4fe6-aded-453f-8a62-ea17b7ca4f35"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"6cf969e9-f643-4cd1-9a89-85a0969b37de","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #590d22\">Level Up Calculations with Subqueries<\/span>","x":75,"y":307,"width":280,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":77,"id":"5e864ad4-fe7a-4b3c-b619-4f3b5c004983","marginOffset":-5.130000000000003,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":25,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Master the art of subqueries to filter, aggregate, and manipulate data within your main query.<\/span>","x":86,"y":411,"width":269,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":154,"id":"0dfefd0d-1494-46fa-a07b-1f7079eb31c3","marginOffset":-4.024999999999999,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #590d22\">Learn More&nbsp;<\/span>","x":130,"y":592,"width":180,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":31,"id":"3ce578ab-984d-43a2-b7d4-d8af00fd7fb8","type":"text","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/introduction-to-sql-for-data-science\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/01\/INTRODUCTION-TO-SQL.jpg","desc":"SQL for Data Science: Importance & Application- Pickl.AI"}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"29765895_7559348-300x300.jpg","width":300,"height":300,"filesize":22060,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-300x300.jpg"},"large":{"file":"29765895_7559348-1024x1024.jpg","width":1024,"height":1024,"filesize":90966,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-1024x1024.jpg"},"thumbnail":{"file":"29765895_7559348-150x150.jpg","width":150,"height":150,"filesize":10687,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-150x150.jpg"},"medium_large":{"file":"29765895_7559348-768x768.jpg","width":768,"height":768,"filesize":65017,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-768x768.jpg"},"1536x1536":{"file":"29765895_7559348-1536x1536.jpg","width":1536,"height":1536,"filesize":147711,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-1536x1536.jpg"},"magine-hero":{"file":"29765895_7559348-1400x600.jpg","width":1400,"height":600,"filesize":76031,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-1400x600.jpg"},"magine-thumbnail":{"file":"29765895_7559348-900x600.jpg","width":900,"height":600,"filesize":64615,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-900x600.jpg"},"magine-vertical-thumbnail":{"file":"29765895_7559348-600x800.jpg","width":600,"height":800,"filesize":62103,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-600x800.jpg"},"web-stories-poster-portrait":{"file":"29765895_7559348-640x853.jpg","width":640,"height":853,"filesize":66848,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-640x853.jpg"},"web-stories-publisher-logo":{"file":"29765895_7559348-96x96.jpg","width":96,"height":96,"filesize":7166,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-96x96.jpg"},"web-stories-thumbnail":{"file":"29765895_7559348-150x150.jpg","width":150,"height":150,"filesize":10687,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348-150x150.jpg"},"full":{"file":"29765895_7559348.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#e1d8e6","blurHash":"UlOWpsOa~T#+.8wbaKNx^#s+ItW;VuNyX8wb","creationDate":"2024-02-29T06:46:48","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29765895_7559348.jpg","id":6438,"alt":"29765895_7559348","local":false},"type":"image","x":53,"y":0,"width":306,"height":280,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"cf427c8c-5a9c-468e-94a7-7e9729fa2df3"}],"backgroundColor":{"color":{"r":182,"g":193,"b":245}},"animations":[],"id":"0cb86558-f2e1-46ec-adb8-ad7f7f5a8a67"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"5580426a-dd5e-4b29-b8a2-4a84cec28735","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #db4e16\">Optimize Performance with Indexes<\/span>","x":66,"y":273,"width":280,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":111,"id":"23a5a8fb-d783-4073-b7fe-0471a0f678b8","marginOffset":-5.130000000000003,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":25,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #131516\">Speed up your queries by strategically creating indexes on frequently used columns.<\/span>","x":98,"y":411,"width":243,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":154,"id":"10862823-68c5-49a1-b67c-8c42e277e1e3","marginOffset":-4.024999999999999,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #db5332\">Learn More&nbsp;<\/span>","x":130,"y":592,"width":180,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":31,"id":"a5e344c8-ba70-4c32-88a2-c9f6fcc448aa","type":"text","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/differences-between-sql-and-t-sql-with-example\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/07\/SQL-vs.-T-SQL-2.jpg","desc":"Differences Between SQL and T-SQL [with Example]- Pickl.AI"}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"29169204_7534532-300x300.jpg","width":300,"height":300,"filesize":21828,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-300x300.jpg"},"large":{"file":"29169204_7534532-1024x1024.jpg","width":1024,"height":1024,"filesize":111061,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-1024x1024.jpg"},"thumbnail":{"file":"29169204_7534532-150x150.jpg","width":150,"height":150,"filesize":7994,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-150x150.jpg"},"medium_large":{"file":"29169204_7534532-768x768.jpg","width":768,"height":768,"filesize":76881,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-768x768.jpg"},"1536x1536":{"file":"29169204_7534532-1536x1536.jpg","width":1536,"height":1536,"filesize":187284,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-1536x1536.jpg"},"magine-hero":{"file":"29169204_7534532-1400x600.jpg","width":1400,"height":600,"filesize":86396,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-1400x600.jpg"},"magine-thumbnail":{"file":"29169204_7534532-900x600.jpg","width":900,"height":600,"filesize":78562,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-900x600.jpg"},"magine-vertical-thumbnail":{"file":"29169204_7534532-600x800.jpg","width":600,"height":800,"filesize":72940,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-600x800.jpg"},"web-stories-poster-portrait":{"file":"29169204_7534532-640x853.jpg","width":640,"height":853,"filesize":79348,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-640x853.jpg"},"web-stories-publisher-logo":{"file":"29169204_7534532-96x96.jpg","width":96,"height":96,"filesize":4160,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-96x96.jpg"},"web-stories-thumbnail":{"file":"29169204_7534532-150x150.jpg","width":150,"height":150,"filesize":7994,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532-150x150.jpg"},"full":{"file":"29169204_7534532.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#98c472","blurHash":"UCJ[|2NI3M%f*J$kvfS47StR=5M_8wRkO[bW","creationDate":"2024-02-28T09:52:45","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/29169204_7534532.jpg","id":6424,"alt":"29169204_7534532","local":false},"type":"image","x":48,"y":0,"width":318,"height":246,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"ab6dedf0-2353-4738-af2d-7097bb4d99a8"}],"backgroundColor":{"color":{"r":238,"g":238,"b":238}},"animations":[],"id":"9bfa9b37-35b8-4eaa-8ad7-a6c82fc8e79f"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"c6d1b1e4-0b26-461e-af82-723679518c75","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #db4e16\">Embrace the Power of Dynamic SQL<\/span>","x":67,"y":232,"width":280,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":77,"id":"83a85487-2ea3-44fe-bbc5-0ba3a4c99bb3","marginOffset":-5.130000000000003,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":26,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #131516\">Build and execute SQL statements on the fly for ultimate flexibility and adaptability.<\/span>","x":67,"y":342,"width":258,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":132,"id":"1b54aec1-b558-43b5-a27b-90e54cd2c141","marginOffset":-4.347000000000001,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":23,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #db5332\">Learn more about advanced SQL and unlock the full potential of your data!<\/span>","x":75,"y":507,"width":272,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":111,"id":"10868ab8-77a5-44ec-943a-cd288aadf39e","type":"text","marginOffset":0.6468749999999979,"link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/\thttps:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/","rel":[],"type":"regular","pageId":null,"icon":"","desc":""}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1440,"sizes":{"medium":{"file":"sql-text-wooden-blocks-business-concept-blue-background-300x169.jpg","width":300,"height":169,"filesize":12349,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-300x169.jpg"},"large":{"file":"sql-text-wooden-blocks-business-concept-blue-background-1024x576.jpg","width":1024,"height":576,"filesize":53975,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-1024x576.jpg"},"thumbnail":{"file":"sql-text-wooden-blocks-business-concept-blue-background-150x150.jpg","width":150,"height":150,"filesize":10577,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-150x150.jpg"},"medium_large":{"file":"sql-text-wooden-blocks-business-concept-blue-background-768x432.jpg","width":768,"height":432,"filesize":35303,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-768x432.jpg"},"1536x1536":{"file":"sql-text-wooden-blocks-business-concept-blue-background-1536x864.jpg","width":1536,"height":864,"filesize":104361,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-1536x864.jpg"},"2048x2048":{"file":"sql-text-wooden-blocks-business-concept-blue-background-2048x1152.jpg","width":2048,"height":1152,"filesize":172467,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-2048x1152.jpg"},"magine-hero":{"file":"sql-text-wooden-blocks-business-concept-blue-background-1400x600.jpg","width":1400,"height":600,"filesize":77228,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-1400x600.jpg"},"magine-thumbnail":{"file":"sql-text-wooden-blocks-business-concept-blue-background-900x600.jpg","width":900,"height":600,"filesize":52551,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-900x600.jpg"},"magine-vertical-thumbnail":{"file":"sql-text-wooden-blocks-business-concept-blue-background-600x800.jpg","width":600,"height":800,"filesize":55450,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-600x800.jpg"},"web-stories-poster-portrait":{"file":"sql-text-wooden-blocks-business-concept-blue-background-640x853.jpg","width":640,"height":853,"filesize":61835,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-640x853.jpg"},"web-stories-publisher-logo":{"file":"sql-text-wooden-blocks-business-concept-blue-background-96x96.jpg","width":96,"height":96,"filesize":8660,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-96x96.jpg"},"web-stories-thumbnail":{"file":"sql-text-wooden-blocks-business-concept-blue-background-150x84.jpg","width":150,"height":84,"filesize":8587,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-150x84.jpg"},"full":{"file":"sql-text-wooden-blocks-business-concept-blue-background-scaled.jpg","width":2560,"height":1440,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#60ceef","blurHash":"UFC^44tl7%t7GcoLvyWXGvoy+Yad:NWVK,s:","creationDate":1709709863000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/sql-text-wooden-blocks-business-concept-blue-background-scaled.jpg","id":6550,"alt":"sql text on wooden blocks, business concept, blue background","local":false},"type":"image","x":46,"y":16,"width":318,"height":183,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"0f99bf55-91b5-4791-b19d-2070813ea0e0"}],"backgroundColor":{"color":{"r":238,"g":238,"b":238}},"animations":[],"id":"12a6697d-0236-47fc-b973-e2878cd7b34d"}],"fonts":{"Karla":{"family":"Karla","fallbacks":["sans-serif"],"weights":[200,300,400,500,600,700,800],"styles":["regular","italic"],"variants":[[0,200],[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[1,200],[1,300],[1,400],[1,500],[1,600],[1,700],[1,800]],"service":"fonts.google.com","metrics":{"upm":2000,"asc":1834,"des":-504,"tAsc":1834,"tDes":-504,"tLGap":0,"wAsc":2062,"wDes":545,"xH":956,"capH":1256,"yMin":-492,"yMax":1952,"hAsc":1834,"hDes":-504,"lGap":0}},"Alegreya":{"family":"Alegreya","fallbacks":["serif"],"weights":[400,500,600,700,800,900],"styles":["regular","italic"],"variants":[[0,400],[0,500],[0,600],[0,700],[0,800],[0,900],[1,400],[1,500],[1,600],[1,700],[1,800],[1,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1016,"des":-345,"tAsc":1016,"tDes":-345,"tLGap":0,"wAsc":1123,"wDes":345,"xH":452,"capH":637,"yMin":-293,"yMax":962,"hAsc":1016,"hDes":-345,"lGap":0}},"Roboto":{"family":"Roboto","weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"fallbacks":["Helvetica Neue","Helvetica","sans-serif"],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}}},"autoAdvance":true,"defaultPageDuration":7,"currentStoryStyles":{"colors":[]}},"story_poster":{"id":6552,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/03\/cropped-6470822.jpg","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6544\/revisions"}],"predecessor-version":[{"id":6553,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6544\/revisions\/6553"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/6552"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media?parent=6544"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=6544"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=6544"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6544\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}