René's URL Explorer Experiment

Title: GitHub - fitsblb/AmazonSQL-Analytics: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.

Open Graph Title: GitHub - fitsblb/AmazonSQL-Analytics: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.

X Title: GitHub - fitsblb/AmazonSQL-Analytics: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.

Description: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures. - fitsblb/AmazonSQL-Analytics

Open Graph Description: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures. - fitsblb/AmazonSQL-Anal...

X Description: 19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures. - fitsblb/AmazonSQL-...

Opengraph URL: https://github.com/fitsblb/AmazonSQL-Analytics

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:1cb40880-3036-dd8c-98fd-7149412fae6f
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	BC84:287BC8:36C5892:4A09798:697077FA
html-safe-nonce	2f8b12a25ba4a7cafaf6f709581d25ef8bd3ebc7edb7fe8ae353ea3c1d3aa9f3
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQzg0OjI4N0JDODozNkM1ODkyOjRBMDk3OTg6Njk3MDc3RkEiLCJ2aXNpdG9yX2lkIjoiODU4NDUzODU3MTk4NzE0ODIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac	34e6f1a0f2b276a314b2ef61c4c17fd5be543b82d01617260f287fdda845b54e
hovercard-subject-tag	repository:1097863690
github-keyboard-shortcuts	repository,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	//
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/fitsblb/AmazonSQL-Analytics
twitter:image	https://opengraph.githubassets.com/1f59fd3e510c96e486367380637179a67df2def3b56ba07d54b4c8c49f1c93f4/fitsblb/AmazonSQL-Analytics
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/1f59fd3e510c96e486367380637179a67df2def3b56ba07d54b4c8c49f1c93f4/fitsblb/AmazonSQL-Analytics
og:image:alt	19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures. - fitsblb/AmazonSQL-Anal...
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	9920a62ba22d06470388e2904804fb7e5ec51c9e35f81784e9191394c74b2bd2
turbo-cache-control	no-preview
go-import	github.com/fitsblb/AmazonSQL-Analytics git https://github.com/fitsblb/AmazonSQL-Analytics.git
octolytics-dimension-user_id	138158520
octolytics-dimension-user_login	fitsblb
octolytics-dimension-repository_id	1097863690
octolytics-dimension-repository_nwo	fitsblb/AmazonSQL-Analytics
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	1097863690
octolytics-dimension-repository_network_root_nwo	fitsblb/AmazonSQL-Analytics
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	7d6181066430cc06553c8396ca201e194ae33cb9
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#start-of-content
	https://patch-diff.githubusercontent.com/
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffitsblb%2FAmazonSQL-Analytics
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub SparkBuild and deploy intelligent apps	https://github.com/features/spark
GitHub ModelsManage and compare prompts	https://github.com/features/models
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffitsblb%2FAmazonSQL-Analytics
Sign up	https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=fitsblb%2FAmazonSQL-Analytics
Reload	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Reload	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Reload	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
fitsblb	https://patch-diff.githubusercontent.com/fitsblb
AmazonSQL-Analytics	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2Ffitsblb%2FAmazonSQL-Analytics
Fork 0	https://patch-diff.githubusercontent.com/login?return_to=%2Ffitsblb%2FAmazonSQL-Analytics
Star 1	https://patch-diff.githubusercontent.com/login?return_to=%2Ffitsblb%2FAmazonSQL-Analytics
1 star	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/stargazers
0 forks	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/forks
Branches	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/branches
Tags	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/tags
Activity	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/activity
Star	https://patch-diff.githubusercontent.com/login?return_to=%2Ffitsblb%2FAmazonSQL-Analytics
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2Ffitsblb%2FAmazonSQL-Analytics
Code	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Issues 0	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/issues
Pull requests 0	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/pulls
Actions	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/actions
Projects 0	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/projects
Security Uh oh! There was an error while loading. Please reload this page.	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/security
Please reload this page	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Insights	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/pulse
Code	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Issues	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/issues
Pull requests	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/pulls
Actions	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/actions
Projects	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/projects
Security	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/security
Insights	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/pulse
Branches	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/branches
Tags	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/tags
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/branches
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/tags
2 Commits	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/commits/main/
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/commits/main/
outputs	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/tree/main/outputs
outputs	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/tree/main/outputs
1_business_problems.sql	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/1_business_problems.sql
1_business_problems.sql	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/1_business_problems.sql
README.md	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/README.md
README.md	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/README.md
README	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#amazon-sql-analytics---business-problems--solutions
	https://www.postgresql.org/
	https://www.postgresql.org/
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/LICENSE
	https://github.com
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-database-schema
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/SCHEMA.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-business-problems--solutions
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q1-top-selling-products
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_1.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_1_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q2-revenue-by-category
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_2.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_2_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q3-average-order-value-aov
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_3.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_3_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q4-monthly-sales-trend
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_4.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_4_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q5-customers-with-no-purchases
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_5.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_5_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q6-best-selling-categories-by-state
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_6.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_6_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q7-customer-lifetime-value-cltv
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_7.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_7_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_8.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_8_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q9-shipping-delays
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_9.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_9_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q10-payment-success-rate
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_10.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_10_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q11-top-performing-sellers
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_11.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_11_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q12-calculate-profit-margin
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_12.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_12_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q13-most-returned-products
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_13.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_13_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q14-inactive-sellers
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_14.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_14_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q15-classify-customers-into-returning-or-new
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_15.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_15_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q16-top-5-customers-by-orders-in-each-state
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_16.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_16_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q17-revenue-by-shipping-provider
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_17.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_17_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q18-top-10-products-with-highest-decreasing-revenue-ratio
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_18.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_18_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#q19-store-procedure-for-inventory-management
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/blob/main/outputs/q_19_output.png
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#️-technologies-used
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-repository-structure
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-key-features
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-learning-outcomes
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-getting-started
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-use-cases
	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#-notes
ecommerce	https://patch-diff.githubusercontent.com/topics/ecommerce
queries	https://patch-diff.githubusercontent.com/topics/queries
sql	https://patch-diff.githubusercontent.com/topics/sql
database	https://patch-diff.githubusercontent.com/topics/database
analytics	https://patch-diff.githubusercontent.com/topics/analytics
postgresql	https://patch-diff.githubusercontent.com/topics/postgresql
data-engineering	https://patch-diff.githubusercontent.com/topics/data-engineering
business-intelligence	https://patch-diff.githubusercontent.com/topics/business-intelligence
sql-optimization	https://patch-diff.githubusercontent.com/topics/sql-optimization
Readme	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics#readme-ov-file
Please reload this page	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics
Activity	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/activity
1 star	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/stargazers
0 watching	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/watchers
0 forks	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/forks
Report repository	https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Ffitsblb%2FAmazonSQL-Analytics&report=fitsblb+%28user%29
Releases	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/releases
Packages 0	https://patch-diff.githubusercontent.com/users/fitsblb/packages?repo_name=AmazonSQL-Analytics
PLpgSQL 100.0%	https://patch-diff.githubusercontent.com/fitsblb/AmazonSQL-Analytics/search?l=plpgsql
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.