{"_id":"61df2a3544f1964f4fa7fba7","author":{"_id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","photo":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","username":"Rajanand"},"badgePageEnabled":true,"description":"I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management & analytics and trainer.","domain":"blog.rajanand.org","domainStatus":{"ready":true,"certIssued":true},"wwwPrefixedDomainStatus":{},"customCSSEnabled":true,"customCSSDraft":{"homeMin":"","postMin":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMin":""},"customCSSPublished":{"homeMin":"","postMin":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMin":""},"customRules":[{"path":"/youtube","destination":"https://youtube.com/@iRajanand","type":301},{"path":"/certifications","destination":"https://www.rajanand.org/certifications/","type":301},{"path":"/linkedin","destination":"http://linkedin.com/in/irajanand","type":301},{"path":"/contact","destination":"https://rajanand.org/contact","type":301}],"darkModeEnabled":false,"darkModeLogo":"","disableFooterBranding":false,"isSubscriptionModalDisabled":false,"publicMembersCount":1,"displayTitle":"blog.rajanand.org","fathomCustomDomain":"","fathomCustomDomainEnabled":false,"fathomSiteID":"","favicon":"","fbPixelID":"1253148365193934","gaTrackingID":"G-41YJ2WRT3K","gTagManagerID":"","hasBadges":true,"headerColor":"#48639C","hideMembersPage":false,"hotjarSiteID":"2780996","imprint":"

Download Scenario based SQL data challenges

\n","isTeam":true,"layout":"stacked","matomoURL":"","membersPageEnabled":true,"menu":[{"_id":"63dbb6cc787b1b79bedc1e02","label":"web","type":"link","url":"https://link.rajanand.org/home"},{"_id":"61dfbe748a0e7c6db7fba500","label":"contact","type":"link","url":"https://link.rajanand.org/bio"},{"_id":"62e9ffbd92b7fd0a78c34f7e","label":"archive","type":"link","url":"https://blog.rajanand.org/archive"},{"_id":"625465d2b32ddd968bbe9cb4","label":"download","type":"link","url":"https://link.rajanand.org/download"}],"metaHTML":"

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

\n","metaHTMLSanitized":"I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.\n","newsletterEnabled":true,"proTeamEnabled":false,"newsletterPageEnabled":false,"ogImage":"","logo":"","textSelectionSharerEnabled":false,"title":"Rajanand's Blog","urlPattern":"simple","username":"rajanand","viewCountVisible":true,"wmPaymentPointer":"","readTimeHidden":false,"links":{"twitter":"https://twitter.com/iRajanand","instagram":"","github":"https://github.com/Rajanand","website":"https://www.rajanand.org","hashnode":"","youtube":"https://www.youtube.com/@iRajanand","dailydev":"","linkedin":"https://linkedin.com/in/irajanand","mastodon":"","facebook":""},"numPosts":76,"sponsorship":{"content":"

I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support.

\n","contentMarkdown":"I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support. \n\n"},"stripe":{"connected":true,"accountId":"acct_1Kjem7SCbsfxEzP7","country":"IN"},"allowContributorEdits":true,"allowCrawlingByGPT":false}

SQL Challenges and Solutions