René's URL Explorer Experiment

Title: GitHub - SimonWang00/data-analysis-sql: 基于hive sql的数据分析工作

Open Graph Title: GitHub - SimonWang00/data-analysis-sql: 基于hive sql的数据分析工作

X Title: GitHub - SimonWang00/data-analysis-sql: 基于hive sql的数据分析工作

Description: 基于hive sql的数据分析工作. Contribute to SimonWang00/data-analysis-sql development by creating an account on GitHub.

Open Graph Description: 基于hive sql的数据分析工作. Contribute to SimonWang00/data-analysis-sql development by creating an account on GitHub.

X Description: 基于hive sql的数据分析工作. Contribute to SimonWang00/data-analysis-sql development by creating an account on GitHub.

Opengraph URL: https://github.com/SimonWang00/data-analysis-sql

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:54b8cb48-bebf-e4fd-c019-2a82544d4662
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	AA40:3ABC38:BE26AA:F48CA6:697DE486
html-safe-nonce	fdaffc80e88fd19362d6904479f080430b7595e856ef726ad81be14b0ae87676
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQTQwOjNBQkMzODpCRTI2QUE6RjQ4Q0E2OjY5N0RFNDg2IiwidmlzaXRvcl9pZCI6IjM4NDcwMDEzNjI2ODg1MDA4NzAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac	93c259d1b69a8fc4682bb661da6edfa75f97711dbfb302912014e7144856e939
hovercard-subject-tag	repository:328657778
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/SimonWang00/data-analysis-sql
twitter:image	https://opengraph.githubassets.com/229b42c67a5c337b74422f6d9ef0f9fa400cd20c88ba9c6004e2d6d7738aec3d/SimonWang00/data-analysis-sql
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/229b42c67a5c337b74422f6d9ef0f9fa400cd20c88ba9c6004e2d6d7738aec3d/SimonWang00/data-analysis-sql
og:image:alt	基于hive sql的数据分析工作. Contribute to SimonWang00/data-analysis-sql development by creating an account on GitHub.
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6
turbo-cache-control	no-preview
go-import	github.com/SimonWang00/data-analysis-sql git https://github.com/SimonWang00/data-analysis-sql.git
octolytics-dimension-user_id	37493968
octolytics-dimension-user_login	SimonWang00
octolytics-dimension-repository_id	328657778
octolytics-dimension-repository_nwo	SimonWang00/data-analysis-sql
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	328657778
octolytics-dimension-repository_network_root_nwo	SimonWang00/data-analysis-sql
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	7c85641c598ad130c74f7bcc27f58575cac69551
ui-target	canary-2
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#start-of-content
	https://patch-diff.githubusercontent.com/
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FSimonWang00%2Fdata-analysis-sql
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%2FSimonWang00%2Fdata-analysis-sql
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=SimonWang00%2Fdata-analysis-sql
Reload	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Reload	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Reload	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
SimonWang00	https://patch-diff.githubusercontent.com/SimonWang00
data-analysis-sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2FSimonWang00%2Fdata-analysis-sql
Fork 1	https://patch-diff.githubusercontent.com/login?return_to=%2FSimonWang00%2Fdata-analysis-sql
Star 5	https://patch-diff.githubusercontent.com/login?return_to=%2FSimonWang00%2Fdata-analysis-sql
5 stars	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/stargazers
1 fork	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/forks
Branches	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/branches
Tags	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/tags
Activity	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/activity
Star	https://patch-diff.githubusercontent.com/login?return_to=%2FSimonWang00%2Fdata-analysis-sql
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2FSimonWang00%2Fdata-analysis-sql
Code	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Issues 0	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/issues
Pull requests 0	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/pulls
Actions	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/actions
Projects 0	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/projects
Security 0	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/security
Insights	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/pulse
Code	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Issues	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/issues
Pull requests	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/pulls
Actions	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/actions
Projects	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/projects
Security	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/security
Insights	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/pulse
Branches	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/branches
Tags	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/tags
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/branches
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/tags
10 Commits	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/commits/main/
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/commits/main/
00.数据分析中的表结构.md	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/00.%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90%E4%B8%AD%E7%9A%84%E8%A1%A8%E7%BB%93%E6%9E%84.md
00.数据分析中的表结构.md	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/00.%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90%E4%B8%AD%E7%9A%84%E8%A1%A8%E7%BB%93%E6%9E%84.md
01.最大的支付日期与最小的支付日期的时间间隔.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/01.%E6%9C%80%E5%A4%A7%E7%9A%84%E6%94%AF%E4%BB%98%E6%97%A5%E6%9C%9F%E4%B8%8E%E6%9C%80%E5%B0%8F%E7%9A%84%E6%94%AF%E4%BB%98%E6%97%A5%E6%9C%9F%E7%9A%84%E6%97%B6%E9%97%B4%E9%97%B4%E9%9A%94.sql
01.最大的支付日期与最小的支付日期的时间间隔.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/01.%E6%9C%80%E5%A4%A7%E7%9A%84%E6%94%AF%E4%BB%98%E6%97%A5%E6%9C%9F%E4%B8%8E%E6%9C%80%E5%B0%8F%E7%9A%84%E6%94%AF%E4%BB%98%E6%97%A5%E6%9C%9F%E7%9A%84%E6%97%B6%E9%97%B4%E9%97%B4%E9%9A%94.sql
02.购买商品的品类在三个以上的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/02.%E8%B4%AD%E4%B9%B0%E5%95%86%E5%93%81%E7%9A%84%E5%93%81%E7%B1%BB%E5%9C%A8%E4%B8%89%E4%B8%AA%E4%BB%A5%E4%B8%8A%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
02.购买商品的品类在三个以上的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/02.%E8%B4%AD%E4%B9%B0%E5%95%86%E5%93%81%E7%9A%84%E5%93%81%E7%B1%BB%E5%9C%A8%E4%B8%89%E4%B8%AA%E4%BB%A5%E4%B8%8A%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
03.支付金额最多的TOP10用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/03.%E6%94%AF%E4%BB%98%E9%87%91%E9%A2%9D%E6%9C%80%E5%A4%9A%E7%9A%84TOP10%E7%94%A8%E6%88%B7.sql
03.支付金额最多的TOP10用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/03.%E6%94%AF%E4%BB%98%E9%87%91%E9%A2%9D%E6%9C%80%E5%A4%9A%E7%9A%84TOP10%E7%94%A8%E6%88%B7.sql
04.统计各个年龄段的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/04.%E7%BB%9F%E8%AE%A1%E5%90%84%E4%B8%AA%E5%B9%B4%E9%BE%84%E6%AE%B5%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
04.统计各个年龄段的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/04.%E7%BB%9F%E8%AE%A1%E5%90%84%E4%B8%AA%E5%B9%B4%E9%BE%84%E6%AE%B5%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
05.用户激活时间在2020年，年龄段在20-30岁和30-40岁的婚姻状况分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/05.%E7%94%A8%E6%88%B7%E6%BF%80%E6%B4%BB%E6%97%B6%E9%97%B4%E5%9C%A82020%E5%B9%B4%EF%BC%8C%E5%B9%B4%E9%BE%84%E6%AE%B5%E5%9C%A820-30%E5%B2%81%E5%92%8C30-40%E5%B2%81%E7%9A%84%E5%A9%9A%E5%A7%BB%E7%8A%B6%E5%86%B5%E5%88%86%E5%B8%83.sql
05.用户激活时间在2020年，年龄段在20-30岁和30-40岁的婚姻状况分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/05.%E7%94%A8%E6%88%B7%E6%BF%80%E6%B4%BB%E6%97%B6%E9%97%B4%E5%9C%A82020%E5%B9%B4%EF%BC%8C%E5%B9%B4%E9%BE%84%E6%AE%B5%E5%9C%A820-30%E5%B2%81%E5%92%8C30-40%E5%B2%81%E7%9A%84%E5%A9%9A%E5%A7%BB%E7%8A%B6%E5%86%B5%E5%88%86%E5%B8%83.sql
06.统计2020年1月到6月，每个品类有多少人购买，累计金额是多少.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/06.%E7%BB%9F%E8%AE%A12020%E5%B9%B41%E6%9C%88%E5%88%B06%E6%9C%88%EF%BC%8C%E6%AF%8F%E4%B8%AA%E5%93%81%E7%B1%BB%E6%9C%89%E5%A4%9A%E5%B0%91%E4%BA%BA%E8%B4%AD%E4%B9%B0%EF%BC%8C%E7%B4%AF%E8%AE%A1%E9%87%91%E9%A2%9D%E6%98%AF%E5%A4%9A%E5%B0%91.sql
06.统计2020年1月到6月，每个品类有多少人购买，累计金额是多少.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/06.%E7%BB%9F%E8%AE%A12020%E5%B9%B41%E6%9C%88%E5%88%B06%E6%9C%88%EF%BC%8C%E6%AF%8F%E4%B8%AA%E5%93%81%E7%B1%BB%E6%9C%89%E5%A4%9A%E5%B0%91%E4%BA%BA%E8%B4%AD%E4%B9%B0%EF%BC%8C%E7%B4%AF%E8%AE%A1%E9%87%91%E9%A2%9D%E6%98%AF%E5%A4%9A%E5%B0%91.sql
07.统计每个性别用户等级的分布情况.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/07.%E7%BB%9F%E8%AE%A1%E6%AF%8F%E4%B8%AA%E6%80%A7%E5%88%AB%E7%94%A8%E6%88%B7%E7%AD%89%E7%BA%A7%E7%9A%84%E5%88%86%E5%B8%83%E6%83%85%E5%86%B5.sql
07.统计每个性别用户等级的分布情况.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/07.%E7%BB%9F%E8%AE%A1%E6%AF%8F%E4%B8%AA%E6%80%A7%E5%88%AB%E7%94%A8%E6%88%B7%E7%AD%89%E7%BA%A7%E7%9A%84%E5%88%86%E5%B8%83%E6%83%85%E5%86%B5.sql
08.统计每月新激活的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/08.%E7%BB%9F%E8%AE%A1%E6%AF%8F%E6%9C%88%E6%96%B0%E6%BF%80%E6%B4%BB%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
08.统计每月新激活的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/08.%E7%BB%9F%E8%AE%A1%E6%AF%8F%E6%9C%88%E6%96%B0%E6%BF%80%E6%B4%BB%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
09.统计不同手机品牌的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/09.%E7%BB%9F%E8%AE%A1%E4%B8%8D%E5%90%8C%E6%89%8B%E6%9C%BA%E5%93%81%E7%89%8C%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
09.统计不同手机品牌的用户数.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/09.%E7%BB%9F%E8%AE%A1%E4%B8%8D%E5%90%8C%E6%89%8B%E6%9C%BA%E5%93%81%E7%89%8C%E7%9A%84%E7%94%A8%E6%88%B7%E6%95%B0.sql
10.统计2020年购买又退款的用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/10.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E8%B4%AD%E4%B9%B0%E5%8F%88%E9%80%80%E6%AC%BE%E7%9A%84%E7%94%A8%E6%88%B7.sql
10.统计2020年购买又退款的用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/10.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E8%B4%AD%E4%B9%B0%E5%8F%88%E9%80%80%E6%AC%BE%E7%9A%84%E7%94%A8%E6%88%B7.sql
11.统计2020年购买用户的学历分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/11.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E8%B4%AD%E4%B9%B0%E7%94%A8%E6%88%B7%E7%9A%84%E5%AD%A6%E5%8E%86%E5%88%86%E5%B8%83.sql
11.统计2020年购买用户的学历分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/11.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E8%B4%AD%E4%B9%B0%E7%94%A8%E6%88%B7%E7%9A%84%E5%AD%A6%E5%8E%86%E5%88%86%E5%B8%83.sql
12.统计2018和2019年购买，但是2020年没有购买的用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/12.%E7%BB%9F%E8%AE%A12018%E5%92%8C2019%E5%B9%B4%E8%B4%AD%E4%B9%B0%EF%BC%8C%E4%BD%86%E6%98%AF2020%E5%B9%B4%E6%B2%A1%E6%9C%89%E8%B4%AD%E4%B9%B0%E7%9A%84%E7%94%A8%E6%88%B7.sql
12.统计2018和2019年购买，但是2020年没有购买的用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/12.%E7%BB%9F%E8%AE%A12018%E5%92%8C2019%E5%B9%B4%E8%B4%AD%E4%B9%B0%EF%BC%8C%E4%BD%86%E6%98%AF2020%E5%B9%B4%E6%B2%A1%E6%9C%89%E8%B4%AD%E4%B9%B0%E7%9A%84%E7%94%A8%E6%88%B7.sql
13.查询2018-2020年所有购买用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/13.%E6%9F%A5%E8%AF%A22018-2020%E5%B9%B4%E6%89%80%E6%9C%89%E8%B4%AD%E4%B9%B0%E7%94%A8%E6%88%B7.sql
13.查询2018-2020年所有购买用户.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/13.%E6%9F%A5%E8%AF%A22018-2020%E5%B9%B4%E6%89%80%E6%9C%89%E8%B4%AD%E4%B9%B0%E7%94%A8%E6%88%B7.sql
14.对2020年每个用户的支付金额和退款金额进行汇总.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/14.%E5%AF%B92020%E5%B9%B4%E6%AF%8F%E4%B8%AA%E7%94%A8%E6%88%B7%E7%9A%84%E6%94%AF%E4%BB%98%E9%87%91%E9%A2%9D%E5%92%8C%E9%80%80%E6%AC%BE%E9%87%91%E9%A2%9D%E8%BF%9B%E8%A1%8C%E6%B1%87%E6%80%BB.sql
14.对2020年每个用户的支付金额和退款金额进行汇总.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/14.%E5%AF%B92020%E5%B9%B4%E6%AF%8F%E4%B8%AA%E7%94%A8%E6%88%B7%E7%9A%84%E6%94%AF%E4%BB%98%E9%87%91%E9%A2%9D%E5%92%8C%E9%80%80%E6%AC%BE%E9%87%91%E9%A2%9D%E8%BF%9B%E8%A1%8C%E6%B1%87%E6%80%BB.sql
15.统计2019年首次注册激活，但是没有支付的用户年龄分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/15.%E7%BB%9F%E8%AE%A12019%E5%B9%B4%E9%A6%96%E6%AC%A1%E6%B3%A8%E5%86%8C%E6%BF%80%E6%B4%BB%EF%BC%8C%E4%BD%86%E6%98%AF%E6%B2%A1%E6%9C%89%E6%94%AF%E4%BB%98%E7%9A%84%E7%94%A8%E6%88%B7%E5%B9%B4%E9%BE%84%E5%88%86%E5%B8%83.sql
15.统计2019年首次注册激活，但是没有支付的用户年龄分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/15.%E7%BB%9F%E8%AE%A12019%E5%B9%B4%E9%A6%96%E6%AC%A1%E6%B3%A8%E5%86%8C%E6%BF%80%E6%B4%BB%EF%BC%8C%E4%BD%86%E6%98%AF%E6%B2%A1%E6%9C%89%E6%94%AF%E4%BB%98%E7%9A%84%E7%94%A8%E6%88%B7%E5%B9%B4%E9%BE%84%E5%88%86%E5%B8%83.sql
16.统计2019年和2020年交易用户，其激活时间分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/16.%E7%BB%9F%E8%AE%A12019%E5%B9%B4%E5%92%8C2020%E5%B9%B4%E4%BA%A4%E6%98%93%E7%94%A8%E6%88%B7%EF%BC%8C%E5%85%B6%E6%BF%80%E6%B4%BB%E6%97%B6%E9%97%B4%E5%88%86%E5%B8%83.sql
16.统计2019年和2020年交易用户，其激活时间分布.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/16.%E7%BB%9F%E8%AE%A12019%E5%B9%B4%E5%92%8C2020%E5%B9%B4%E4%BA%A4%E6%98%93%E7%94%A8%E6%88%B7%EF%BC%8C%E5%85%B6%E6%BF%80%E6%B4%BB%E6%97%B6%E9%97%B4%E5%88%86%E5%B8%83.sql
17.统计2020年每月的支付总额和当年的累计支付总额.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/17.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E6%AF%8F%E6%9C%88%E7%9A%84%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D%E5%92%8C%E5%BD%93%E5%B9%B4%E7%9A%84%E7%B4%AF%E8%AE%A1%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D.sql
17.统计2020年每月的支付总额和当年的累计支付总额.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/17.%E7%BB%9F%E8%AE%A12020%E5%B9%B4%E6%AF%8F%E6%9C%88%E7%9A%84%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D%E5%92%8C%E5%BD%93%E5%B9%B4%E7%9A%84%E7%B4%AF%E8%AE%A1%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D.sql
18.统计2019，2020年每月的支付总额和当年的累计总额.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/18.%E7%BB%9F%E8%AE%A12019%EF%BC%8C2020%E5%B9%B4%E6%AF%8F%E6%9C%88%E7%9A%84%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D%E5%92%8C%E5%BD%93%E5%B9%B4%E7%9A%84%E7%B4%AF%E8%AE%A1%E6%80%BB%E9%A2%9D.sql
18.统计2019，2020年每月的支付总额和当年的累计总额.sql	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/18.%E7%BB%9F%E8%AE%A12019%EF%BC%8C2020%E5%B9%B4%E6%AF%8F%E6%9C%88%E7%9A%84%E6%94%AF%E4%BB%98%E6%80%BB%E9%A2%9D%E5%92%8C%E5%BD%93%E5%B9%B4%E7%9A%84%E7%B4%AF%E8%AE%A1%E6%80%BB%E9%A2%9D.sql
README.md	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/README.md
README.md	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/README.md
README	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#data-analysis-sql
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#1建模用到的模型表
数据仓库模型	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/blob/main/00.%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90%E4%B8%AD%E7%9A%84%E8%A1%A8%E7%BB%93%E6%9E%84.md
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#2日常工作中常用的hive语句归纳
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#1统计指定用户2020年的平均支付金额以及2020年最大的支付日期与最小的支付日期的时间间隔
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#2统计2020年购买商品的品类在三个以上的用户数
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#3统计2020年11月支付金额最多的top10用户
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#4统计以下四个年龄段20岁以下20-30岁30-40岁和40岁以上的用户数
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#5用户激活时间在2020年年龄段在20-30岁和30-40岁的婚姻状况分布
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#6统计2020年1月到6月每个品类有多少人购买累计金额是多少
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#7统计每个性别用户等级的分布情况
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#8统计每月新激活的用户数
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#9统计不同手机品牌的用户数
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#10统计2020年购买又退款的用户
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#11统计2020年购买用户的学历分布
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#12统计2018和2019年购买但是2020年没有购买的用户
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#13查询2018-2020年所有购买用户
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#14对2020年每个用户的支付金额和退款金额进行汇总
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#15统计2019年首次注册激活但是没有支付的用户年龄分布
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#16统计2019年和2020年交易用户其激活时间分布
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#17统计2020年每月的支付总额和当年的累计支付总额
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#18统计20192020年每月的支付总额和当年的累计总额
	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#19统计出2020年支付金额排名在第102030名的用户
Readme	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql#readme-ov-file
Please reload this page	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql
Activity	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/activity
5 stars	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/stargazers
1 watching	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/watchers
1 fork	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/forks
Report repository	https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2FSimonWang00%2Fdata-analysis-sql&report=SimonWang00+%28user%29
Releases	https://patch-diff.githubusercontent.com/SimonWang00/data-analysis-sql/releases
Packages 0	https://patch-diff.githubusercontent.com/users/SimonWang00/packages?repo_name=data-analysis-sql
	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.