{"id":36610,"date":"2024-05-06T19:05:20","date_gmt":"2024-05-06T13:35:20","guid":{"rendered":"https:\/\/www.foundit.in\/career-advice\/?post_type=web-story&#038;p=36610"},"modified":"2024-05-06T19:14:27","modified_gmt":"2024-05-06T13:44:27","slug":"sql-interview-questions-for-data-analysts","status":"publish","type":"web-story","link":"https:\/\/www.foundit.in\/career-advice\/web-stories\/sql-interview-questions-for-data-analysts\/","title":{"rendered":"10 SQL Interview questions for Data Analysts"},"content":{"rendered":"<p><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=Roboto%3Awght%40400%3B700&amp;family=Roboto+Condensed\" rel=\"stylesheet\"><style amp-boilerplate=\"\">body @-webkit-keyframes -amp-start to }@-moz-keyframes -amp-start to }@-ms-keyframes -amp-start to }@-o-keyframes -amp-start to }@keyframes -amp-start to }<\/style><p><noscript><\/noscript><\/p><style amp-boilerplate=\"\">body <\/style><p><\/p><style amp-custom=\"\">\n              h1, h2, h3  \n<p>              amp-story-page  \n<p>              amp-story-grid-layer  \n<p>              @media (max-aspect-ratio: 9 \/ 16)   \n                }\n              }\n<p>              @media not all and (min-resolution:.001dpcm)  \n                }\n              }\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area  \n<p>              .element-overlay-area  \n<p>              .page-safe-area  \n<p>              .mask  \n<p>              .fill  \n<p>              @media (prefers-reduced-motion: no-preference)  \n              }\n<p>              amp-story-grid-layer.align-bottom  \n<p>              .captions-area  \n<p>              amp-story-captions  \n<p>              amp-story-captions span  \n              <\/style><p><meta name=\"web-stories-replace-head-start\"><\/p><title>10 SQL Interview questions for Data Analysts<\/title><link rel=\"canonical\" href=\"https:\/\/www.foundit.in\/career-advice\/web-stories\/sql-interview-questions-for-data-analysts\/\"><meta name=\"web-stories-replace-head-end\"><body><amp-story standalone=\"\" publisher=\"foundit\" publisher-logo-src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/09\/Logo.png\" title=\"10 SQL Interview questions for Data Analysts\" poster-portrait-src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/640x853-poster-image-min-1-7.jpg\"><amp-story-page id=\"fd1f122f-073e-46b8-849f-317c971e5295\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-f2e01be1-787f-4e81-955e-55869f5aa05b\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-10.43689%;width:100%;height:120.87379%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;transform:scale3d(1, -1, 1)\" class=\"mask\" id=\"el-6575c191-159c-4f8b-a247-cc1cbebffcda\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.16505%;top:6.47249%;width:77.6699%;height:17.63754%;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% 0% 0% 0% \/ 0% 0% 0% 0%\" id=\"el-255486be-e9ba-4e60-81d3-8999d6816e52\">\n<h1 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.35937499999999956% 0;font-family:\"Roboto\",sans-serif;font-size:0.517799em;line-height:1.1;text-align:center;padding:0;color:#000000'><span><span>10 SQL Interview questions for Data Analysts<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-2.18447%;top:34.46602%;width:102.42718%;height:76.05178%;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-af9a01c9-cb22-4341-a93d-6400c316e711\">\n<div style=\"position:absolute;width:111.37441%;height:100%;left:-0.06886%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-07-min.jpg\" alt=\"Concept top SQL interview questions for data analysts in 2024\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(5.82524% - 2px);top:calc(-3.8835% - 2px);width:calc(11.65049% + 4px);height:calc(7.76699% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(110,0,190,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-e3316497-bef8-4b4e-8358-c0d4f9a73e68\">\n<div style=\"position:absolute;width:100%;height:100.00004%;left:0%;top:-0.00002%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/10\/Logo-Square-2.jpg\" alt=\"foundit logo\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:59.70874%;top:28.80259%;width:28.8835%;height:3.39806%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-378ad86c-4f4b-4bb3-9519-4ce3aa8f77b7\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-2.4816176470588234% 0;font-family:\"Roboto Condensed\",sans-serif;font-size:0.291262em;line-height:1.5;text-align:center;padding:0;color:#000000'><span><span>By Team foundit<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:28.80259%;width:26.94175%;height:3.55987%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-4fe38ad8-8eac-4861-b70f-ea1c65d63409\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-2.660472972972973% 0;font-family:\"Roboto Condensed\",sans-serif;font-size:0.291262em;line-height:1.5;text-align:left;padding:0;color:#000000'><span><span>May 6, 2024<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"a043597d-c6bc-4a89-81a7-76104c01dbf5\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-76224e81-a7f8-44b9-9ab3-7719f7d064c6\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-dc754cd1-cc69-4cee-800c-2f3085b9e8c4\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-21969145-6342-471c-8c2a-07045a509639\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-fe32e742-312e-4f02-8868-0f1682f222b4\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-9302343b-c748-4b71-af30-7f0642bb8422\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-803ed105-b2d9-4674-a0ca-d5d839d9213c\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-001-1500x1500-04-min.jpg\" alt=\"Presentation in office or meeting room with analyst team utilizing BI Fintech to analyze data. Concept Land your dream Data Analyst role in India\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:5.66343%;width:80.58252%;height:10.67961%;opacity:1\">\n<div id=\"anim-806ba99a-23a3-4779-a952-33c9e489623c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-939d1ac1-9d9c-4290-8ff5-16b8a0a4e252\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 3.0303030303030303% 3.0303030303030303% 3.0303030303030303% 3.0303030303030303%\" id=\"el-cf929ee6-006d-4bc6-86eb-20b80d2b4990\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>SQL Questions for Data Analysts<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.40777%;top:19.90291%;width:76.94175%;height:11.48867%;opacity:1\">\n<div id=\"anim-b2e48354-7f4d-472c-bced-203fb323cb11\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-a3152769-d9d2-43ce-a730-3cca9302b1f2\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-f62c0676-339b-48e6-b9cf-46c0e82c679a\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>Land your dream Data Analyst role in India! &nbsp;Prepare with these top 10 SQL interview questions.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-65b2ef93-bd28-4680-b05c-5806e8f8c0e2\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-1000df32-eea4-4bbc-8a2c-64f3fbd9eaf5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"b10c0b12-95dd-477b-bcf0-6ffbb3b5e519\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-ca6b15e3-826d-4524-802d-dd61be42343b\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-5926d92e-a583-4792-8c9c-560a9f96bcbf\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-1274817b-e93d-4e3a-b229-d1955dffe0c7\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-575b8304-c1e3-428a-a60a-af6f03ee06ed\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-3cc5875f-e3c9-4afc-be67-f1b6c1145631\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-62e0e2f0-6ff4-41d1-a6db-a818b5f5f501\">\n<div style=\"position:absolute;width:191.0828%;height:100%;left:-4.66839%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers.jpg\" alt=\"SQL printed on a paper kept on the keypad. Concept Can you explain what SQL is used for? SQL Questions for Data Analysts\" srcset=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers.jpg 1200w,https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-1068x559.jpg 1068w,https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-1024x536.jpg 1024w,https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-768x402.jpg 768w,https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-696x364.jpg 696w,https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-300x157.jpg 300w\" sizes=\"(min-width: 1024px) 37vh, 83vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-f8011bee-d8a1-40d4-b9d8-fd3f51207b6e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-12c29d2a-b110-4c15-b775-dabf2ffb4d3c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-be4bda86-516f-431f-a1d0-267cc9eef315\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>1. What is SQL?<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.40777%;top:23.13916%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-e032f445-fe5e-4d08-ade0-76c15fa9c030\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-6518dc27-0bd4-40a2-9718-8136b56f2581\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-bf522408-3d7d-4cd8-aca5-1b9479258aab\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>Can you explain what SQL is used for?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-2e7d6391-06ce-408a-9e13-3b2600f2df83\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-dd93dec4-f4a9-4fd7-87f6-361a0303024e\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"7a3e631d-7d95-4fad-ae95-1d17fdac81e7\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-623ae261-dea6-4fd8-9728-e30a25f51387\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-d74a00f9-02e9-4503-a8dd-042b075fe3b3\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-0f6f2c59-a8ba-42dd-8948-b7ebd1dfbe2f\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-5e30add9-1bd3-4bfe-9135-cb565cad792b\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-cd1cd9e9-dccf-4a3a-832d-714f2ddd3d64\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-901fe6ec-ea71-4819-8c56-67b38d1b7046\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-03-min.jpg\" alt=\"Christmas card with digital christmas tree; concept of Common SQL Functions, Most Asked  SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:10.67961%;opacity:1\">\n<div id=\"anim-f55e5ade-d511-4b00-a00e-48767547af10\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-258ff34e-2325-4d1e-9746-f8afe1ae8190\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 3.0303030303030303% 3.0303030303030303% 3.0303030303030303% 3.0303030303030303%\" id=\"el-a328789b-eccc-40a3-b6a3-b1c0794d7a97\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>2. Common SQL Functions<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.40777%;top:24.75728%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-f045dca2-46d3-431c-9031-0315e2e7ed88\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-8fa91fa8-f925-4410-a9b0-448e601285fd\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-e8f8a050-c7c2-43eb-8653-8679c92d4b63\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>What are some frequently used SQL functions?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-6ba73166-2229-4808-b0ab-e901f8b2ebf5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-929aad7b-601a-4df1-84d9-1c7422cca9de\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"640602f5-4c00-4068-b4eb-379feb9821eb\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-39de0c6a-34bd-4b0a-98c0-27945f05f8b5\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-ed2b9f6a-f65f-42db-b28e-34e758a2629b\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-54f130fa-86a8-4ac0-8019-e5e145155810\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-ce6f8793-2535-4311-a60b-2fa202311270\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-4f576663-0759-4fed-a319-fae1dcc2531a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-3b89bc3e-02fc-4cf7-b5f8-e9cb903bad0a\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-12-min.jpg\" alt=\"Data science and big data technology. Scientist computing, analysing and visualizing complex data set on computer. Data mining, artificial intelligence, machine learning, business analytics; concept of Most Asked SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-67de5f56-e008-45ee-98bb-d371022031b0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-31d6ff13-b136-4914-b112-99b7cd7528f4\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-7345e0e5-15fa-4956-b221-2a7dcd5aec18\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>3. Filtering Data<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:24.75728%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-6491f5f2-893c-4039-9748-ba4054013a54\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-73c9b365-d4be-400c-b3b0-5189b65f16c3\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-1ab464d1-280b-4e1a-92eb-19590b80e935\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span>How can you filter data in SQL using the WHERE clause?<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-a91914af-85bb-43b9-b6a8-ae2ff9c0d3ec\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-ac808ed1-3652-4378-aa6b-ab5434a6bf7c\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"d5a3ab7b-0176-4b26-8900-b7a45aaee0a6\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-3ebad938-45d9-4422-8e42-e8aa25b71a59\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-bdd95d29-daa5-44fd-91ba-88e43f37f2e3\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-04d34b0c-881a-4fb1-83d2-1b221a1f7a24\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-4912e1a0-5399-46ce-ab7d-8587bc97947e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-7ae2c714-0db1-4e32-86fe-795321d1ce2b\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-d058947e-9257-4961-918c-ca5f26a586fc\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-09-min.jpg\" alt=\"Left outer join and right outer join in SQL; Concept of common Interview questions in SQL\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-96bf3f70-3e14-4e46-9177-c9db9d60c5e0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2b0508ee-d2d7-4615-a008-ed17b3c72584\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-816dda5f-ae59-4a98-af49-964442c0a5e0\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>4. Join the Tables<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:19.90291%;width:76.94175%;height:11.48867%;opacity:1\">\n<div id=\"anim-05a4bd76-ba69-4c51-bdfa-27dd2a3a7169\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-c61691d0-246d-4b3c-9a5d-e263d9578418\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-184e2e8c-1774-41c8-a0d9-7a92f1616d51\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span>Explain the different types of joins (INNER, LEFT, RIGHT) used to combine data from multiple tables.<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-9173fa6a-b978-4f0f-a3f6-ef27cf47d77f\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-2b1f18dd-0d0e-41f1-aab1-b232faea3ccc\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"4326d106-cdcf-4231-9195-20ed68644577\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-55dee680-e469-4a89-879d-0f7009ced8b9\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-594baf2c-7429-4d99-98d8-1107838a8e44\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-b1bfc07e-db93-4f33-9b40-a29a6a17c33b\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-0df894f8-5ba6-4c86-812b-a206d5a16d50\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-ec5946c3-1a03-48d5-bfee-91fc2f8e4ead\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-6027df18-83b1-4d85-a475-00a7b62d15cd\">\n<div style=\"position:absolute;width:100%;height:216.42512%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/12\/Web-story-17-828x1792-07-min.jpg\" alt=\"Connecting dots forming networks Concept different types of  Grouping Data in SQL. Most asked SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-aa140aa1-d077-4bc9-a175-5fb98e30e5da\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-6f50277c-c5b9-4c89-b07d-3a6740753503\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-248d83c7-f930-410c-afba-903c0a8636a4\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>5. Grouping Data<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-eece7615-f886-4834-9eca-8acf63f30b0c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-e95ab78f-fa2c-4a58-89a6-9134f65be45d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-32030269-b3fe-469d-ba2c-f8c5b9c273db\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>How can you group data and calculate aggregate values in SQL?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-5c336c9b-1677-4b48-83fe-b8cf9ff2a9f6\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-8fcedaf2-00c4-45d9-bce2-9e2135abac40\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"df7c6d99-fa74-4539-9070-556d1b851ca4\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-c7236be1-06b5-47d4-ad3e-fc879710d6d9\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-6c95323a-d009-4998-9c8d-47e89bac9fcc\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-9c8adc9d-9d98-4370-9727-6742c639d6ec\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-be04c391-b48f-43b9-8e63-655f23644ff7\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-29b19f84-43a8-4fa6-9cd6-82e4d14ca232\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-20cca643-18ed-482a-b215-7593512482d8\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-05-min.jpg\" alt=\"What is a subquery and how can you use it in SQL?, Concept of Common SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-baf1c121-e855-4387-a355-f37dd5275b43\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-c95da416-a2d0-4e62-b943-e08832ddd3e0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-4a907d79-8cf8-4e58-b0c9-8eb68a182c59\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>6. Subqueries<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-c08e123f-d00c-4e02-acbc-65622b85bc12\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-2d97ea24-8067-449e-9bb4-a4d6e9bafc86\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-10d26e86-4615-4d6e-a3d1-5c7ef4cf61db\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>What is a subquery and how can you use it in SQL?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-f6932db8-c303-411d-b9e5-02201cc52d96\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-d64e296a-7894-4071-893b-566692664d52\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"a9101c77-36f7-4bfe-aced-6d852cb6da78\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-1161016d-5cb8-46b2-90f1-91367cf20651\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-5ad751e6-c967-42c9-9099-734fe5dde2f5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-bcbff3dd-a9e1-46f0-8858-9e1f09ac59e8\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-aabd44c5-756f-425b-aed6-a8f57626b3a1\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-4e911c9a-d007-4144-a876-3571d515972a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-c2def560-9249-442f-9fb2-3acbd76328d4\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-08-min.jpg\" alt=\"Database Indexing on SQL; Concept of Common SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-e01a4018-ce48-478d-9e9a-3c5f0bfd834a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-7bfb51ac-054a-4f46-aeba-28221a82cc8f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-ad2aaafe-ef61-4609-926e-f10e1b7b04c1\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>7. Window Functions<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-5fa5d9f2-a535-40d8-9e98-25a5930a8f6f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-19fb9688-0285-4308-b518-f4a760b011d0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-fec75b56-d037-4561-b11a-b763411b9cde\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span>What are window functions and how are they used in SQL?<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-f8a2fa25-0cd6-4979-b940-b0ddc1754928\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-5e6847f6-8bb4-441f-81f0-bfc3a33de6f5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"31086a6e-0732-42ce-947f-86d0840c3820\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-25d8932b-bbc7-42dc-a6c7-e9dcf0e5178b\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-d839d454-94c5-4186-8e90-ea67e4c094e5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-53767086-b02b-4c0c-b3e0-0d4e0c4c1cc5\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-78e4eedf-ff4a-4cb7-8aa3-e8866acda247\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-a8c05f6e-818a-4c7b-a2e1-7c04f34f44e7\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-26a0ef32-f6f6-49c4-9ddf-c21841c1adcc\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-05-min.jpg\" alt=\"Solving problem and How to control the number of rows returned by your query using LIMIT? concept of Most Asked SQL Interview Questions\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-8ff3139d-9376-41ef-b594-6f8102c3ed1a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-14329429-9037-42c3-847f-07f06fc18c2e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-d7919a86-7a06-4937-89bf-c419b7e1126b\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>8. Limit Your Results<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:7.60518%;opacity:1\">\n<div id=\"anim-d2f89c51-d834-4ffa-a092-d162e609906c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-a065cb10-05a6-4081-9e27-39711ca1cb17\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-d8e6776e-5e4a-4ce9-a66c-f1ceffff7f58\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span>How to control the number of rows returned by your query using LIMIT?<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-e5a2af8d-f266-4382-999c-b4957bbc86f2\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-ca048ffe-3fe6-4483-b295-9b5ec05881ea\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"c6a4ea8a-4b37-4c10-ade3-b84b8fe60e4a\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-fe8977e3-af14-4a81-9d8c-ad851d9e79f7\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-c56a6b5c-570f-4b06-a6a6-efe9ddb144bf\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-736b614f-74e3-4b60-b391-bb72a79a34d0\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-0aafb0aa-3532-4848-8e7a-61d3595cb465\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-6e55a713-b0d7-4a6f-9871-77c1d5f91bd0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-e0867b85-e6a8-4ca3-89b1-4afaf3d8b034\">\n<div style=\"position:absolute;width:100%;height:133.28125%;left:0%;top:-17.31092%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/03\/640x853-poster-image-min-1-11.jpg\" alt=\"Young female data scientist is thinking about the statistics;  use the ORDER BY clause to sort your query results in ascending or descending order. Concept SQL Questions for Data Analysts\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-f7340c81-9d28-4eef-9cc2-6a39b1237f66\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-f707bd55-d0b5-4030-9eb2-d225f0c00c85\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-a545dd9b-5e1a-4d3f-8efb-2a766ebb4903\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>9. Sort It Out<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:11.48867%;opacity:1\">\n<div id=\"anim-d8d68f40-f081-4881-bd0c-1120148975a0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-af30c342-7baa-4616-9eeb-e7b6308d15d9\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-01e47af4-50e5-4281-939f-0396aff691f4\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>How to use the ORDER BY clause to sort your query results in ascending or descending order.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-13d6f02c-ad03-4e51-bc3d-86917fa67b9a\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-197756e7-e6fb-41be-80b8-f2e6e2b41287\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"53c1a6f8-6238-4e3a-ae0d-936de1103b01\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-9d2dbeb2-bb8b-46e5-a60c-1e6aca44f298\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-5224aff1-90b6-4e3c-843e-96990c4043a1\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-b7288c05-8bf5-4eb9-af46-7a0fb4ec5556\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-6afa9fdf-de61-43b5-a04f-dcd48d56fcec\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-7bb588e1-c967-4139-b640-a0c0e96b132d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-06fed391-b95f-489b-b211-c77b8b5c775f\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/05\/Web-story-015-1500x1500-06-min.jpg\" alt=\"Graphic representation of a Binary Search Tree structure; Can you explain the difference between DDL and DML statements?, concept of tackling common interview questions in SQL interviews.\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.50162%;opacity:1\">\n<div id=\"anim-56a39450-313d-4720-9b17-512a21a7c582\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-4022ecb9-fbc4-49f2-bb2d-22535129f296\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.88235294117647% 5.88235294117647% 5.88235294117647% 5.88235294117647%\" id=\"el-c302c7a0-bfef-4d36-bb8e-86cc93dde14d\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11859939759036166% 0;font-family:\"Roboto\",sans-serif;font-size:0.453074em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>10. Beyond the Basics<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:21.0356%;width:76.94175%;height:11.48867%;opacity:1\">\n<div id=\"anim-0fe45df4-e84a-4346-9893-e9c30ddf5112\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-4d2ed019-9ca6-49da-949e-567f7db71ece\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-60fbb644-ae6b-475c-88c5-5accbeda820a\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>Can you explain the difference between DDL and DML statements?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-2efc0d16-ee72-4f1d-abde-7348fa73475d\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-81aeba4b-20ab-4327-a424-272e370c737a\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"c0d97aae-6aff-4ca6-8501-46f31222b4fe\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":10,\"duration\":1500,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[ ,\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-8061ed2d-cb2b-4b40-8f04-91e5885a26dd\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-5.58252%;top:-9.70874%;width:113.83495%;height:85.92233%;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-21121c49-ce9a-467d-a438-5e5959efbe4a\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:calc(6.31068% - 2px);top:calc(45.46926% - 2px);width:calc(87.37864% + 4px);height:calc(58.25243% + 4px);opacity:1\">\n<div style=\"top:0;left:0;right:0;bottom:0;width:100%;height:100%;position:absolute;border-width:2px 2px 2px 2px;border-color:rgba(255,255,255,1);border-style:solid;pointer-events:initial;display:block;z-index:0\" class=\"mask\" id=\"el-ff19f022-3ea6-4c33-964b-77cffcdf0f1e\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:47.08738%;width:82.52427%;height:55.01618%;opacity:1\">\n<div id=\"anim-aa2581d1-0f7e-467e-a63a-28d187336e6a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:none\">\n<div id=\"anim-9ff3a1fd-8e9c-41b7-bab5-3cf56cc9e044\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(3)\">\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-7c145203-27bb-485e-a8a1-dd6268aed405\">\n<div style=\"position:absolute;width:100%;height:216.42512%;left:0%;top:-18.95402%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/01\/Web-story-31-828x1792-10-min.jpg\" alt=\"job seeker browsing work opportunities online using job search computer app, jobless seeker looking for new vacancies on website page at laptop screen, recruitment concept,\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.70874%;top:7.28155%;width:80.58252%;height:5.98706%;opacity:1\">\n<div id=\"anim-333d6372-dec6-4903-9809-5324285d0fe7\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-89583d57-60c8-40ee-9e57-9cb90a2885c8\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6024096385542169% 0.6024096385542169% 0.6024096385542169% 0.6024096385542169% \/ 5.405405405405405% 5.405405405405405% 5.405405405405405% 5.405405405405405%\" id=\"el-db6faf82-4766-48f5-8d7f-81cccff06b35\">\n<h2 class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.13554216867469857% 0;font-family:\"Roboto\",sans-serif;font-size:0.517799em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>Ready To Apply<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.40777%;top:18.28479%;width:76.94175%;height:11.48867%;opacity:1\">\n<div id=\"anim-eed37106-8e25-4bd0-aa62-c8e94bd3e373\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-d1d02dbb-e943-4592-b117-db8e9d7f02d5\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 2.8169014084507045% 2.8169014084507045% 2.8169014084507045% 2.8169014084507045%\" id=\"el-850f4425-476b-4e95-bfa9-277f3c6c6fb0\">\n<p class=\"fill text-wrapper\" style='white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.0887223974763407% 0;font-family:\"Roboto\",sans-serif;font-size:0.323625em;line-height:1.2;text-align:center;padding:0;color:#000000'><span><span>Don&rsquo;t wait! Update your resume and register at foundit to apply for these exciting opportunities.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:73.30097%;top:0;width:46.1165%;height:0.64725%;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-c9581d1b-7ca3-474f-a215-743ed17233e2\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-16.99029%;top:41.74757%;width:46.1165%;height:0.64725%;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-ac5fdd3e-3eba-4ab4-9421-45ab44420fb3\">\n<div class=\"fill\" will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png\"><a href=\"https:\/\/www.foundit.in\/seeker\/registration?utm_source=discover&amp;utm_medium=webstory&amp;utm_campaign=sql-interview-questions-for-data-analysts\" rel=\"\">Register Now<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"c35f5ed4-6101-4829-9ae2-296e1a36524c\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\" >\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-19267915-49c9-45e2-a63b-c1a692423600\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\">\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:18.4466%;top:26.69903%;width:63.1068%;height:37.37864%;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% 0% 0% 0% \/ 0% 0% 0% 0%\" class=\"mask\" id=\"el-534c10b8-f66f-4c37-9062-2126405ede71\"><a href=\"https:\/\/www.foundit.in?utm_source=discover&amp;utm_medium=webstory&amp;utm_campaign=sql-interview-questions-for-data-analysts\" data-tooltip-icon=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png\" data-tooltip-text=\"Latest Jobs in India (2024), Job Vacancies, Recruitment - foundit Formerly Monster\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"position:absolute;width:102.26895%;height:100%;left:-1.13447%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/image-2.png\" alt=\"foundit, best online job portal\"><\/amp-img><\/div>\n<p><\/p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png\"><a href=\"https:\/\/www.foundit.in?utm_source=discover&amp;utm_medium=webstory&amp;utm_campaign=sql-interview-questions-for-data-analysts\" rel=\"\">Explore Now<\/a><\/amp-story-page-outlink><\/amp-story-page><\/amp-story>\n<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Web Story explores top SQL interview questions for data analysts in 2024. Master these SQL questions frequently asked by employers and impress with your data skills.<\/p>\n","protected":false},"author":1,"featured_media":35988,"template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"web_stories_publisher_logo":20600,"web_stories_poster":[],"web_stories_products":[],"footnotes":""},"web_story_category":[137],"web_story_tag":[],"class_list":["post-36610","web-story","type-web-story","status-publish","has-post-thumbnail","hentry"],"aioseo_notices":[],"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,"id":"f2e01be1-787f-4e81-955e-55869f5aa05b","type":"shape"},{"opacity":100,"flip":{"vertical":true,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":110,"g":0,"b":190}},"x":0,"y":-64.5,"width":412,"height":747,"mask":{"type":"rectangle"},"id":"6575c191-159c-4f8b-a247-cc1cbebffcda","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":32,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.1,"textAlign":"center","padding":{"vertical":0,"horizontal":0,"locked":true},"content":"<span style=\"font-weight: 700; color: #fff\">10 SQL Interview questions for Data Analysts<\/span>","borderRadius":{"locked":true,"topLeft":0,"topRight":0,"bottomRight":0,"bottomLeft":0},"x":46,"y":40,"width":320,"height":109,"id":"255486be-e9ba-4e60-81d3-8999d6816e52","tagName":"h1","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":44.95544197765843,"focalY":49.90206129748761,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#24224e","blurHash":"UM5~^pk=tQocxzVraKX8Z*V[V[V[ozpHk9jE","creationDate":"2024-04-16T11:52:58.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-07-min.jpg","id":35575,"alt":"Concept top SQL interview questions for data analysts in 2024","local":false},"x":-9,"y":213,"width":422,"height":470,"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":"af9a01c9-cb22-4341-a93d-6400c316e711","type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":96,"height":96,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#891acc","blurHash":"ULSr}=xua#ogxufjayf7_KWDj?t5s;f7kBj[","creationDate":1696598492000,"src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/10\/Logo-Square-2.jpg","id":21317,"alt":"foundit logo","local":false},"x":24,"y":-24,"width":48,"height":48,"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":"e3316497-bef8-4b4e-8358-c0d4f9a73e68","border":{"locked":true,"color":{"color":{"r":110,"g":0,"b":190}},"left":2,"right":2,"top":2,"bottom":2},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto Condensed"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.5,"textAlign":"center","padding":{"locked":true,"horizontal":0,"vertical":0},"content":"<span style=\"color: rgba(255,255,255,0.7)\">By Team foundit<\/span>","marginOffset":5.578125,"x":246,"y":178,"width":119,"height":21,"id":"378ad86c-4f4b-4bb3-9519-4ce3aa8f77b7","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto Condensed"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.5,"textAlign":"left","padding":{"locked":true,"horizontal":0,"vertical":0},"content":"<span style=\"color: rgba(255,255,255,0.7)\">May 6, 2024<\/span>","marginOffset":5.578125,"x":48,"y":178,"width":111,"height":22,"id":"4fe38ad8-8eac-4861-b70f-ea1c65d63409","type":"text"}],"backgroundColor":{"color":{"r":223,"g":227,"b":228}},"animations":[],"id":"fd1f122f-073e-46b8-849f-317c971e5295","type":"page","pageTemplateType":"cover","image":{"id":35373,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35372.jpg","needsProxy":false,"isExternal":false}},{"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":"76224e81-a7f8-44b9-9ab3-7719f7d064c6","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":225,"g":25,"b":160}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"dc754cd1-cc69-4cee-800c-2f3085b9e8c4","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"21969145-6342-471c-8c2a-07045a509639","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#c3cdd2","blurHash":"UMH{KN4qRQ%M.9x^NfWA_M$^Riof-%$_s+R-","creationDate":"2024-04-29T14:56:50.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-001-1500x1500-04-min.jpg","id":36238,"alt":"Presentation in office or meeting room with analyst team utilizing BI Fintech to analyze data. Concept Land your dream Data Analyst role in India","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"803ed105-b2d9-4674-a0ca-d5d839d9213c","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">SQL Questions for Data Analysts<\/span>","x":40,"y":35,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":66,"id":"cf929ee6-006d-4bc6-86eb-20b80d2b4990","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">Land your dream Data Analyst role in India! &nbsp;Prepare with these top 10 SQL interview questions.<\/span>","x":47,"y":123,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":71,"id":"f62c0676-339b-48e6-b9cf-46c0e82c679a","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"65b2ef93-bd28-4680-b05c-5806e8f8c0e2","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"1000df32-eea4-4bbc-8a2c-64f3fbd9eaf5","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"669d6deb-663f-4c84-9d74-33a7db507bed","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["803ed105-b2d9-4674-a0ca-d5d839d9213c"]},{"id":"222f4e8c-3001-4cd9-b690-6c63ea9de488","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["cf929ee6-006d-4bc6-86eb-20b80d2b4990"]},{"id":"fa3b637a-7b8f-46f6-93b7-cb5d00ae364c","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["f62c0676-339b-48e6-b9cf-46c0e82c679a"]}],"id":"a043597d-c6bc-4a89-81a7-76104c01dbf5","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"ca6b15e3-826d-4524-802d-dd61be42343b","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":0,"g":163,"b":255}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"5926d92e-a583-4792-8c9c-560a9f96bcbf","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"1274817b-e93d-4e3a-b229-d1955dffe0c7","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":28.60978886907912,"focalY":50.00074052285818,"resource":{"type":"image","mimeType":"image\/jpeg","width":1200,"height":628,"sizes":{"medium":{"file":"sql-interview-questions-for-testers-300x157.jpg","width":300,"height":157,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-300x157.jpg"},"large":{"file":"sql-interview-questions-for-testers-1024x536.jpg","width":1024,"height":536,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-1024x536.jpg"},"thumbnail":{"file":"sql-interview-questions-for-testers-150x150.jpg","width":150,"height":150,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-150x150.jpg"},"medium_large":{"file":"sql-interview-questions-for-testers-768x402.jpg","width":768,"height":402,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-768x402.jpg"},"td_218x150":{"file":"sql-interview-questions-for-testers-218x150.jpg","width":218,"height":150,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-218x150.jpg"},"td_324x400":{"file":"sql-interview-questions-for-testers-324x400.jpg","width":324,"height":400,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-324x400.jpg"},"td_485x360":{"file":"sql-interview-questions-for-testers-485x360.jpg","width":485,"height":360,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-485x360.jpg"},"td_696x0":{"file":"sql-interview-questions-for-testers-696x364.jpg","width":696,"height":364,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-696x364.jpg"},"td_1068x0":{"file":"sql-interview-questions-for-testers-1068x559.jpg","width":1068,"height":559,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers-1068x559.jpg"},"full":{"file":"sql-interview-questions-for-testers.jpg","width":1200,"height":628,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#7a99b3","blurHash":"UPHBfI+HGwR~4:sp$*RPPTOWoNxvjDS$S3xG","creationDate":"2022-05-12T11:10:45.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2022\/03\/sql-interview-questions-for-testers.jpg","id":12391,"alt":"SQL printed on a paper kept on the keypad. Concept Can you explain what SQL is used for? SQL Questions for Data Analysts","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"62e0e2f0-6ff4-41d1-a6db-a818b5f5f501","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">1. What is SQL?<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"be4bda86-516f-431f-a1d0-267cc9eef315","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">Can you explain what SQL is used for?<\/span>","x":47,"y":143,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"bf522408-3d7d-4cd8-aca5-1b9479258aab","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"2e7d6391-06ce-408a-9e13-3b2600f2df83","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"dd93dec4-f4a9-4fd7-87f6-361a0303024e","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"1bbcbf6d-cffb-4ccc-9de7-4c16af304912","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["62e0e2f0-6ff4-41d1-a6db-a818b5f5f501"]},{"id":"4de7d5f7-700b-4f90-a233-ae4b206daad4","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["be4bda86-516f-431f-a1d0-267cc9eef315"]},{"id":"2fc9cc10-c794-4314-a0d7-4253e283d4dc","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["bf522408-3d7d-4cd8-aca5-1b9479258aab"]}],"id":"b10c0b12-95dd-477b-bcf0-6ffbb3b5e519","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"623ae261-dea6-4fd8-9728-e30a25f51387","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":110,"g":0,"b":190}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"d74a00f9-02e9-4503-a8dd-042b075fe3b3","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"0f6f2c59-a8ba-42dd-8948-b7ebd1dfbe2f","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#040d0d","blurHash":"U20L6ed=Y+g$f+g3eTenY+g3l.eTg3enghg3","creationDate":"2024-04-21T07:25:16.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-03-min.jpg","id":35788,"alt":"Christmas card with digital christmas tree; concept of Common SQL Functions, Most Asked  SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"901fe6ec-ea71-4819-8c56-67b38d1b7046","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">2. Common SQL Functions<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":66,"id":"a328789b-eccc-40a3-b6a3-b1c0794d7a97","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">What are some frequently used SQL functions?<\/span>","x":47,"y":153,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"e8f8a050-c7c2-43eb-8653-8679c92d4b63","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"6ba73166-2229-4808-b0ab-e901f8b2ebf5","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"929aad7b-601a-4df1-84d9-1c7422cca9de","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"cdd28995-fa34-4920-8e34-47fb084944b0","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["901fe6ec-ea71-4819-8c56-67b38d1b7046"]},{"id":"47a9b968-ca84-4092-8cfc-c754a1fbf891","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["a328789b-eccc-40a3-b6a3-b1c0794d7a97"]},{"id":"73b871f8-82ec-4726-8be9-ecf4b5c58151","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["e8f8a050-c7c2-43eb-8653-8679c92d4b63"]}],"id":"7a3e631d-7d95-4fad-ae95-1d17fdac81e7","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"39de0c6a-34bd-4b0a-98c0-27945f05f8b5","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":170,"b":0}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"ed2b9f6a-f65f-42db-b28e-34e758a2629b","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"54f130fa-86a8-4ac0-8019-e5e145155810","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#1d2648","blurHash":"U78;ZQ_M020cFkX5$%o#0JM|=_xu=UxaN~WA","creationDate":"2024-04-21T07:25:38.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-12-min.jpg","id":35797,"alt":"Data science and big data technology. Scientist computing, analysing and visualizing complex data set on computer. Data mining, artificial intelligence, machine learning, business analytics; concept of Most Asked SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"3b89bc3e-02fc-4cf7-b5f8-e9cb903bad0a","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">3. Filtering Data<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"7345e0e5-15fa-4956-b221-2a7dcd5aec18","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"How can you filter data in SQL using the WHERE clause?","x":48,"y":153,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"1ab464d1-280b-4e1a-92eb-19590b80e935","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"a91914af-85bb-43b9-b6a8-ae2ff9c0d3ec","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"ac808ed1-3652-4378-aa6b-ab5434a6bf7c","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"ffe25002-6da8-49fb-a711-3d6b1cb21611","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["3b89bc3e-02fc-4cf7-b5f8-e9cb903bad0a"]},{"id":"b092c054-47a8-4034-979d-8b8670c6aae4","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["7345e0e5-15fa-4956-b221-2a7dcd5aec18"]},{"id":"116c9d42-f55d-427d-bd36-24336876f7fe","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["1ab464d1-280b-4e1a-92eb-19590b80e935"]}],"id":"640602f5-4c00-4068-b4eb-379feb9821eb","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"3ebad938-45d9-4422-8e42-e8aa25b71a59","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":115,"g":215,"b":195}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"bdd95d29-daa5-44fd-91ba-88e43f37f2e3","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"04d34b0c-881a-4fb1-83d2-1b221a1f7a24","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#282a27","blurHash":"UBBgC~_400M__4WWD$%200D$%N%g4ToJ-=E1","creationDate":"2024-04-16T11:53:00.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-09-min.jpg","id":35577,"alt":"Left outer join and right outer join in SQL; Concept of common Interview questions in SQL","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"d058947e-9257-4961-918c-ca5f26a586fc","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">4. Join the Tables<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"816dda5f-ae59-4a98-af49-964442c0a5e0","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"Explain the different types of joins (INNER, LEFT, RIGHT) used to combine data from multiple tables.","x":48,"y":123,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":71,"id":"184e2e8c-1774-41c8-a0d9-7a92f1616d51","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"9173fa6a-b978-4f0f-a3f6-ef27cf47d77f","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"2b1f18dd-0d0e-41f1-aab1-b232faea3ccc","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"0a8b9aec-cb95-4db1-86ab-3facdb0da86b","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["d058947e-9257-4961-918c-ca5f26a586fc"]},{"id":"6c267a83-2a34-4962-91e9-7bff21d086a2","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["816dda5f-ae59-4a98-af49-964442c0a5e0"]},{"id":"7f6708b0-00ba-4e89-bbb0-425b14e0e060","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["184e2e8c-1774-41c8-a0d9-7a92f1616d51"]}],"id":"d5a3ab7b-0176-4b26-8900-b7a45aaee0a6","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"55dee680-e469-4a89-879d-0f7009ced8b9","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":252,"g":95,"b":0}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"594baf2c-7429-4d99-98d8-1107838a8e44","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"b1bfc07e-db93-4f33-9b40-a29a6a17c33b","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":49.986733100222516,"focalY":22.996417405062253,"resource":{"type":"image","mimeType":"image\/jpeg","width":828,"height":1792,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#545454","blurHash":"U6Bf;Cs:NbxY~Ut6R*xZt8oLWBxYs:NHR+j@","creationDate":"2023-12-18T05:45:46.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/12\/Web-story-17-828x1792-07-min.jpg","id":33269,"alt":"Connecting dots forming networks Concept different types of  Grouping Data in SQL. Most asked SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"6027df18-83b1-4d85-a475-00a7b62d15cd","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">5. Grouping Data<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"248d83c7-f930-410c-afba-903c0a8636a4","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">How can you group data and calculate aggregate values in SQL?<\/span>","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"32030269-b3fe-469d-ba2c-f8c5b9c273db","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"5c336c9b-1677-4b48-83fe-b8cf9ff2a9f6","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"8fcedaf2-00c4-45d9-bce2-9e2135abac40","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"11e33594-24c6-4411-9633-444d9f5cb40a","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["6027df18-83b1-4d85-a475-00a7b62d15cd"]},{"id":"90b64f0b-ecee-4d76-94ec-795b5b832f63","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["248d83c7-f930-410c-afba-903c0a8636a4"]},{"id":"c0ece15c-9d8f-407d-b851-273f4ccc78b5","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["32030269-b3fe-469d-ba2c-f8c5b9c273db"]}],"id":"4326d106-cdcf-4231-9195-20ed68644577","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"c7236be1-06b5-47d4-ad3e-fc879710d6d9","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":0,"g":163,"b":255}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"6c95323a-d009-4998-9c8d-47e89bac9fcc","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"9c8adc9d-9d98-4370-9727-6742c639d6ec","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#413988","blurHash":"UJE26$E10^${}?IoIrt3G0nLxan-ELave:Na","creationDate":"2024-04-16T11:52:57.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-05-min.jpg","id":35574,"alt":"What is a subquery and how can you use it in SQL?, Concept of Common SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"20cca643-18ed-482a-b215-7593512482d8","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">6. Subqueries<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"4a907d79-8cf8-4e58-b0c9-8eb68a182c59","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">What is a subquery and how can you use it in SQL?<\/span>","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"10d26e86-4615-4d6e-a3d1-5c7ef4cf61db","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"f6932db8-c303-411d-b9e5-02201cc52d96","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"d64e296a-7894-4071-893b-566692664d52","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"0bec157c-fcb8-4663-94b1-df26739bf7dc","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["20cca643-18ed-482a-b215-7593512482d8"]},{"id":"0f1f1486-105e-45b7-a702-28d552cad336","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["4a907d79-8cf8-4e58-b0c9-8eb68a182c59"]},{"id":"b2835a3c-89e2-4053-af39-01a6f64bb59c","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["10d26e86-4615-4d6e-a3d1-5c7ef4cf61db"]}],"id":"df7c6d99-fa74-4539-9070-556d1b851ca4","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"1161016d-5cb8-46b2-90f1-91367cf20651","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":115,"g":215,"b":195}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"5ad751e6-c967-42c9-9099-734fe5dde2f5","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"bcbff3dd-a9e1-46f0-8858-9e1f09ac59e8","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#1b213c","blurHash":"UE8~4.9qvnob}_D~X9t7zBV@O8xbaIW9NEob","creationDate":"2024-04-16T11:52:59.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-002-1500x1500-08-min.jpg","id":35576,"alt":"Database Indexing on SQL; Concept of Common SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"c2def560-9249-442f-9fb2-3acbd76328d4","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">7. Window Functions<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"ad2aaafe-ef61-4609-926e-f10e1b7b04c1","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"What are window functions and how are they used in SQL?","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"fec75b56-d037-4561-b11a-b763411b9cde","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"f8a2fa25-0cd6-4979-b940-b0ddc1754928","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"5e6847f6-8bb4-441f-81f0-bfc3a33de6f5","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"25a23f86-6af9-4dd3-a149-433ede47d5d1","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["c2def560-9249-442f-9fb2-3acbd76328d4"]},{"id":"a6d194c2-040e-4f28-9c2c-d54abd432b1f","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["ad2aaafe-ef61-4609-926e-f10e1b7b04c1"]},{"id":"7aec7003-4e70-48ac-8a08-71937f6b044c","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["fec75b56-d037-4561-b11a-b763411b9cde"]}],"id":"a9101c77-36f7-4bfe-aced-6d852cb6da78","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"25d8932b-bbc7-42dc-a6c7-e9dcf0e5178b","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":170,"b":0}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"d839d454-94c5-4186-8e90-ea67e4c094e5","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"53767086-b02b-4c0c-b3e0-0d4e0c4c1cc5","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#d6d9dc","blurHash":"UbOMy;R$?^V}X:n$njI=pJWBVrV?i_W=WAen","creationDate":"2024-04-21T07:25:19.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/Web-story-006-1500x1500-05-min.jpg","id":35790,"alt":"Solving problem and How to control the number of rows returned by your query using LIMIT? concept of Most Asked SQL Interview Questions","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"26a0ef32-f6f6-49c4-9ddf-c21841c1adcc","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">8. Limit Your Results<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"d7919a86-7a06-4937-89bf-c419b7e1126b","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"How to control the number of rows returned by your query using LIMIT?","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":47,"id":"d8e6776e-5e4a-4ce9-a66c-f1ceffff7f58","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"e5a2af8d-f266-4382-999c-b4957bbc86f2","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"ca048ffe-3fe6-4483-b295-9b5ec05881ea","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"48c46ce8-e601-4785-a3c6-08afaa7e2199","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["26a0ef32-f6f6-49c4-9ddf-c21841c1adcc"]},{"id":"43d5b40a-9298-43be-b49e-9904d752dc5d","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["d7919a86-7a06-4937-89bf-c419b7e1126b"]},{"id":"a28ba5ed-5fe7-41bd-aa86-5229648500e8","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["d8e6776e-5e4a-4ce9-a66c-f1ceffff7f58"]}],"id":"31086a6e-0732-42ce-947f-86d0840c3820","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"fe8977e3-af14-4a81-9d8c-ad851d9e79f7","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":110,"g":0,"b":190}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"c56a6b5c-570f-4b06-a6a6-efe9ddb144bf","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"736b614f-74e3-4b60-b391-bb72a79a34d0","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":49.99066171824289,"focalY":50.502920671574614,"resource":{"type":"image","mimeType":"image\/jpeg","width":640,"height":853,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#5a737a","blurHash":"UPE:i1~q.9%2t9-;%gj?pJD%IANFT0tRnNM{","creationDate":"2024-03-12T10:07:35.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/03\/640x853-poster-image-min-1-11.jpg","id":34839,"alt":"Young female data scientist is thinking about the statistics;  use the ORDER BY clause to sort your query results in ascending or descending order. Concept SQL Questions for Data Analysts","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"e0867b85-e6a8-4ca3-89b1-4afaf3d8b034","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">9. Sort It Out<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"a545dd9b-5e1a-4d3f-8efb-2a766ebb4903","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">How to use the ORDER BY clause to sort your query results in ascending or descending order.<\/span>","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":71,"id":"01e47af4-50e5-4281-939f-0396aff691f4","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"13d6f02c-ad03-4e51-bc3d-86917fa67b9a","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"197756e7-e6fb-41be-80b8-f2e6e2b41287","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"3582b1ef-a006-406a-ac83-27c57be052c2","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["e0867b85-e6a8-4ca3-89b1-4afaf3d8b034"]},{"id":"0d826e22-a059-4955-b355-c55ff83fb37b","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["a545dd9b-5e1a-4d3f-8efb-2a766ebb4903"]},{"id":"3be04495-0f38-4f9a-b540-48dbdaeae0c0","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["01e47af4-50e5-4281-939f-0396aff691f4"]}],"id":"c6a4ea8a-4b37-4c10-ade3-b84b8fe60e4a","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"9d2dbeb2-bb8b-46e5-a60c-1e6aca44f298","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":252,"g":95,"b":0}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"5224aff1-90b6-4e3c-843e-96990c4043a1","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"b7288c05-8bf5-4eb9-af46-7a0fb4ec5556","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":28.10661761352287,"resource":{"type":"image","mimeType":"image\/jpeg","width":1500,"height":1500,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#f38c94","blurHash":"U3S2$goLL#oLiwfQkWfQHXf6uifQtRf6aKfQ","creationDate":"2024-05-03T04:45:27.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/05\/Web-story-015-1500x1500-06-min.jpg","id":36489,"alt":"Graphic representation of a Binary Search Tree structure; Can you explain the difference between DDL and DML statements?, concept of tackling common interview questions in SQL interviews.","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":36,"y":291,"mask":{"type":"rectangle"},"id":"06fed391-b95f-489b-b211-c77b8b5c775f","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">10. Beyond the Basics<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":34,"id":"c302c7a0-bfef-4d36-bb8e-86cc93dde14d","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">Can you explain the difference between DDL and DML statements?<\/span>","x":48,"y":130,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":71,"id":"60fbb644-ae6b-475c-88c5-5accbeda820a","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"2efc0d16-ee72-4f1d-abde-7348fa73475d","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"81aeba4b-20ab-4327-a424-272e370c737a","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"931a0c1c-e190-450c-840d-c252a5a796af","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["06fed391-b95f-489b-b211-c77b8b5c775f"]},{"id":"9ab6d498-3d24-4b94-87c8-59e59bd0683b","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["c302c7a0-bfef-4d36-bb8e-86cc93dde14d"]},{"id":"73ad1f58-06b0-4d9c-aa3f-8bbd9cbcfeb0","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["60fbb644-ae6b-475c-88c5-5accbeda820a"]}],"id":"53c1a6f8-6238-4e3a-ae0d-936de1103b01","image":{"id":35375,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35374.jpg","needsProxy":false,"isExternal":false}},{"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":"8061ed2d-cb2b-4b40-8f04-91e5885a26dd","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":225,"g":25,"b":160}},"width":469,"height":531,"x":-23,"y":-60,"mask":{"type":"rectangle"},"id":"21121c49-ce9a-467d-a438-5e5959efbe4a","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":0,"g":0,"b":0,"a":0}},"width":360,"height":360,"x":26,"y":281,"mask":{"type":"rectangle"},"id":"ff19f022-3ea6-4c33-964b-77cffcdf0f1e","border":{"left":2,"right":2,"top":2,"bottom":2,"lockedWidth":true,"color":{"color":{"r":255,"g":255,"b":255}}},"type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"scale":100,"focalX":50.000000000000014,"focalY":31.860452946233064,"resource":{"type":"image","mimeType":"image\/jpeg","width":828,"height":1792,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#d3d0c4","blurHash":"UfMaIi-;kDf5_4D%t8a{_NxtWCRjj;R*oMof","creationDate":"2024-01-23T07:29:49.000Z","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/01\/Web-story-31-828x1792-10-min.jpg","id":33825,"alt":"job seeker browsing work opportunities online using job search computer app, jobless seeker looking for new vacancies on website page at laptop screen, recruitment concept,","local":false},"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"width":340,"height":340,"x":40,"y":291,"mask":{"type":"rectangle"},"id":"7c145203-27bb-485e-a8a1-dd6268aed405","border":{"left":0,"right":0,"top":0,"bottom":0,"lockedWidth":true,"color":{"color":{"r":0,"g":0,"b":0}}},"alt":"job seeker browsing work opportunities online using job search computer app, jobless seeker looking for new vacancies on website page at laptop screen, recruitment concept,","type":"image"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":32,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">Ready To Apply<\/span>","x":40,"y":45,"width":332,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":37,"id":"db6faf82-4766-48f5-8d7f-81cccff06b35","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">Don't wait! Update your resume and register at foundit to apply for these exciting opportunities.<\/span>","x":47,"y":113,"width":317,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":71,"id":"850f4425-476b-4e95-bfa9-277f3c6c6fb0","type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":302,"y":0,"mask":{"type":"rectangle"},"id":"c9581d1b-7ca3-474f-a215-743ed17233e2","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"width":190,"height":4,"x":-70,"y":258,"mask":{"type":"rectangle"},"id":"ac5fdd3e-3eba-4ab4-9421-45ab44420fb3","type":"shape"}],"backgroundColor":{"color":{"r":240,"g":240,"b":240}},"animations":[{"id":"d92fb9f5-7fea-4e50-ae67-74658d9aad55","type":"effect-zoom","scaleDirection":"scaleOut","duration":1500,"delay":10,"targets":["7c145203-27bb-485e-a8a1-dd6268aed405"]},{"id":"d77bbfe0-dd06-49a5-98ee-e45a5638d75a","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["db6faf82-4766-48f5-8d7f-81cccff06b35"]},{"id":"e7372b35-7b40-44fa-951a-28bff06e164c","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["850f4425-476b-4e95-bfa9-277f3c6c6fb0"]}],"id":"c0d97aae-6aff-4ca6-8501-46f31222b4fe","image":{"id":35722,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35721.jpg","needsProxy":false,"isExternal":false},"pageAttachment":{"url":"https:\/\/www.foundit.in\/seeker\/registration?utm_source=discover&utm_medium=webstory&utm_campaign=sql-interview-questions-for-data-analysts","icon":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png","needsProxy":false,"ctaText":"Register Now"}},{"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":"19267915-49c9-45e2-a63b-c1a692423600","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","width":160,"height":139,"sizes":[],"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#8624c8","blurHash":"UHRo{lt7_Kog.6Rlx@t5DkoeRkRl%fWCaej?","creationDate":"2024-04-11T05:53:50","src":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/image-2.png","id":35377,"alt":"image","local":false},"x":76,"y":165,"width":260,"height":231,"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":"534c10b8-f66f-4c37-9062-2126405ede71","borderRadius":{"topLeft":0,"topRight":0,"bottomRight":0,"bottomLeft":0,"locked":false},"alt":"foundit, best online job portal","link":{"needsProxy":false,"url":"https:\/\/www.foundit.in?utm_source=discover&utm_medium=webstory&utm_campaign=sql-interview-questions-for-data-analysts","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png","desc":"Latest Jobs in India (2024), Job Vacancies, Recruitment - foundit Formerly Monster"},"type":"image"}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"animations":[],"id":"c35f5ed4-6101-4829-9ae2-296e1a36524c","pageAttachment":{"url":"https:\/\/www.foundit.in?utm_source=discover&utm_medium=webstory&utm_campaign=sql-interview-questions-for-data-analysts","icon":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2023\/11\/Logo.png","needsProxy":false,"ctaText":"Explore Now"},"image":{"id":35379,"height":600,"width":400,"url":"https:\/\/media.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/web-stories-page-template-35378.jpg","needsProxy":false,"isExternal":false}}],"fonts":{"Roboto":{"family":"Roboto","fallbacks":["sans-serif"],"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]],"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}},"Roboto Condensed":{"family":"Roboto Condensed","fallbacks":["sans-serif"],"weights":[300,400,700],"styles":["italic","regular"],"variants":[[0,300],[1,300],[0,400],[1,400],[0,700],[1,700]],"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":35988,"url":"https:\/\/www.foundit.in\/career-advice\/wp-content\/uploads\/2024\/04\/640x853-poster-image-min-1-7.jpg","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web-story\/36610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/users\/1"}],"version-history":[{"count":3,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web-story\/36610\/revisions"}],"predecessor-version":[{"id":36641,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web-story\/36610\/revisions\/36641"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/media\/35988"}],"wp:attachment":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/media?parent=36610"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web_story_category?post=36610"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web_story_tag?post=36610"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/web-story\/36610\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/web-stories\/v1\/media\/20600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}