{"publication":{"__typename":"Publication","id":"61df2a3544f1964f4fa7fba7","url":"https://blog.rajanand.org","canonicalURL":"https://blog.rajanand.org","urlPattern":"SIMPLE","title":"Rajanand's Blog","displayTitle":"blog.rajanand.org","hasBadges":true,"descriptionSEO":"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.","about":{"html":"

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","text":"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","__typename":"Content"},"features":{"newsletter":{"isEnabled":true,"__typename":"NewsletterFeature"},"viewCount":{"isEnabled":true,"__typename":"ViewCountFeature"},"readTime":{"isEnabled":true,"__typename":"ReadTimeFeature"},"textSelectionSharer":{"isEnabled":false,"__typename":"TextSelectionSharerFeature"},"customCSS":{"isEnabled":true,"published":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"draft":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"__typename":"CustomCSSFeature"},"__typename":"PublicationFeatures"},"metaTags":"\n\n\n\n $\"Clicky\"$ \n\n\n\n\n\n\n","ogMetaData":{"image":null,"__typename":"OpenGraphMetaData"},"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png"},"preferences":{"__typename":"Preferences","logo":null,"darkMode":{"__typename":"DarkModePreferences","logo":null,"enabled":false},"navbarItems":[{"__typename":"PublicationNavbarItem","id":"63dbb6cc787b1b79bedc1e02","label":"web","url":"https://link.rajanand.org/home","priority":3,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"61dfbe748a0e7c6db7fba500","label":"contact","url":"https://link.rajanand.org/bio","priority":1,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"62e9ffbd92b7fd0a78c34f7e","label":"archive","url":"https://blog.rajanand.org/archive","priority":1,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"625465d2b32ddd968bbe9cb4","label":"download","url":"https://link.rajanand.org/download","priority":0,"type":"link","series":null,"page":null}],"enabledPages":{"__typename":"PagesPreferences","badges":false,"newsletter":true,"members":null},"layout":"stacked","disableFooterBranding":false,"isSubscriptionModalDisabled":false},"favicon":null,"headerColor":"#48639C","integrations":{"fbPixelID":"1253148365193934","fathomSiteID":"","fathomCustomDomainEnabled":false,"fathomCustomDomain":"","hotjarSiteID":"2780996","matomoSiteID":null,"matomoURL":"","gaTrackingID":"G-41YJ2WRT3K","plausibleAnalyticsEnabled":null,"wmPaymentPointer":"","umamiWebsiteUUID":null,"__typename":"PublicationIntegrations"},"imprintV2":{"__typename":"Content","html":"

Download Scenario based SQL data challenges

\n"},"postsCount":{"totalDocuments":76,"__typename":"PublicationPostConnection"},"isTeam":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":"","mastodon":"","__typename":"PublicationLinks"},"domainInfo":{"__typename":"DomainInfo","hashnodeSubdomain":"rajanand","domain":{"__typename":"DomainStatus","host":"blog.rajanand.org","ready":true},"wwwPrefixedDomain":null},"redirectionRules":[{"source":"/youtube","destination":"https://youtube.com/@iRajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/certifications","destination":"https://www.rajanand.org/certifications/","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/linkedin","destination":"http://linkedin.com/in/irajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/contact","destination":"https://rajanand.org/contact","type":"PERMANENT","__typename":"RedirectionRule"}],"totalRecommendedPublications":0,"sponsorship":{"content":{"html":"

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","markdown":"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","__typename":"Content"},"stripe":{"connected":true,"accountId":"acct_1Kjem7SCbsfxEzP7","country":"IN","__typename":"StripeConfiguration"},"__typename":"PublicationSponsorship"},"pro":null,"allowContributorEdits":true,"series":{"id":"62988ff673bf2e0f1abc9f06","name":"SQL Challenges","coverImage":"","slug":"sql-challenges","description":{"html":"Download the SQL data challenges script to create the test data, solutions and PDF copy of all the challenges for beginners to advanced.\nhttps://link.rajanand.org/sql-challenges\n","markdown":"Download the SQL data challenges script to create the test data, solutions and PDF copy of all the challenges for beginners to advanced.\n\n\nhttps://link.rajanand.org/sql-challenges","text":"Download the SQL data challenges script to create the test data, solutions and PDF copy of all the challenges for beginners to advanced.\nhttps://link.rajanand.org/sql-challenges\n","__typename":"Content"},"cuid":"cl3wvfcff003m35nvh2lrbjzb","author":{"id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","__typename":"User"},"posts":{"edges":[{"node":{"__typename":"Post","id":"644225df2344f5b0afa4e8e3","title":"Finding Top Customers Who Ordered Every Week","slug":"finding-top-customers-who-ordered-every-week","publishedAt":"2023-04-21T05:57:51.214Z","cuid":"clgq541ym000708mh1xf0ayb9","url":"https://blog.rajanand.org/finding-top-customers-who-ordered-every-week","subtitle":"SQL Challenges","brief":"The Problem\nYou have been given a table Orders that contain the following columns:\n\nOrderId (int)\n\nCustomerId (int)\n\nOrderDate (datetime)\n\nTotalAmount (money)\n\n\nYou need to find the top 2 customers who have spent the most money in the last 30 days. H...","readTimeInMinutes":4,"views":237,"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","username":"Rajanand","name":"Rajanand Ilangovan","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","followersCount":25},"coverImage":null},"cursor":"NjQ0MjI1ZGYyMzQ0ZjViMGFmYTRlOGUzXzIwMjMtMDQtMjFUMDU6NTc6NTEuMjE0Wg==","__typename":"PostEdge"}],"pageInfo":{"endCursor":"NjQ0MjI1ZGYyMzQ0ZjViMGFmYTRlOGUzXzIwMjMtMDQtMjFUMDU6NTc6NTEuMjE0Wg==","hasNextPage":false,"__typename":"PageInfo"},"__typename":"SeriesPostConnection"},"__typename":"Series"}}}