Mercari-analytics-report

KO | EN

gitlite — search

#typescript #sql #generative-ai #mcp #agent #go #svg #awesome #docker #git

Mercari-analytics-report

(★ 9)

No description available.

File Explorer

ZIP Download

mercari_analytics_report.sql
mercari_platform_report_v2.sql
mini_project_README.md
README.md
week3_test.sql

# Use via CDN

jsDelivr

jsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.

Version

File

Link

Example

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

A real-world SQL analytics project analyzing a simulated Mercari Japan
user dataset. Built as the Week 1 capstone of my 30-day SQL mastery journey.

---

## Project Overview

This project answers 8 real business questions a Data Analyst at
Mercari Japan would face — using only a `users` table and pure SQL.

No Python. No Pandas. Just SQL.

---

## Business Questions Answered

| Section | Business Question |
|---|---|
| 1 | What is our overall user base? |
| 2 | How are users distributed across countries? |
| 3 | Which are our top 3 biggest markets? |
| 4 | Which markets have the youngest demographics? |
| 5 | Which email providers do our users prefer? |
| 6 | What generations are our users from? |
| 7 | Which are core vs emerging markets? |
| 8 | Gmail adoption rate in our top markets? |

---

## Dataset

Simulated `users` table — 11 rows across 6 countries.

| Column | Type | Description |
|---|---|---|
| user_id | INT (PK) | Auto-incremented unique ID |
| username | VARCHAR(50) | Unique username |
| email | VARCHAR(100) | Unique email |
| country | VARCHAR(50) | User's country |
| age | INT | User's age |
| created_at | DATETIME | Account creation time |

**Countries covered:** India, Japan, USA, Germany, China, Mexico

---

## SQL Concepts Used

- SELECT, FROM, WHERE
- AND, OR, IN, BETWEEN, LIKE
- ORDER BY, LIMIT
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY, HAVING
- CASE WHEN (for segmentation)

---

## Sample Output

**Section 2 — Market Breakdown:**

| country | users | avg_age | youngest | oldest |
|---|---|---|---|---|
| India | 4 | 23.5 | 17 | 31 |
| Japan | 3 | 23.0 | 19 | 28 |
| Germany | 1 | 29.0 | 29 | 29 |
| USA | 1 | 34.0 | 34 | 34 |
| China | 1 | 24.0 | 24 | 24 |
| Mexico | 1 | 27.0 | 27 | 27 |

---

## How to Run

1. Install MySQL 8.0 + MySQL Workbench
2. Run `setup.sql` first to create database and load data
3. Open `mercari_analytics_report.sql`
4. Run each section with `Ctrl + Enter`

---

## Part of My SQL Journey

This mini project is the Week 1 capstone of my 30-day SQL mastery plan.

Main repo: [mercaridb-sql](https://github.com/Prashant-4527/mercaridb-sql)

**Goal:** AI Engineer at Mercari Japan by 2028 🇯🇵

---

*Pure SQL. Real questions. One week of learning.*

Mercari-analytics-report

Owner Repos

File Explorer

# Use via CDN

Was this content helpful?

Recent Feedback

Mercari-analytics-report

Owner Repos

File Explorer

# Use via CDN

Was this content helpful?

Recent Feedback

Download README