SQL Project - Business model Customer to Customer (C2C)

Business model Customer to Customer (C2C)

The model is growing fast with e-commerce platforms where sellers may be required to pay some amount and buyer can buy it without paying anything. E-Commerce website brings the seller and buyer to the same platform.

Analyzing the user's database will lead to understanding the business perspective. Behaviour of the users can be traced in terms of business with exploration of the user’s database.

Explorated important information for current and future uses.

Gender wise users and its followers comparison. Calcuated total number of users using profile pictures, application, having android app, ios app, calculated total number of buyers country wise, checking the choices of genders of being sellers or buyers, checking countries with maximum buyers and more which gives an overview and behaviour of the users on eccomerce platform, analysis of products and its profits.

Extracted data can be used for the analysis of the ecommerce platform and its growth.

Skills used: MySQL(Union, Joins, Functions, Subquery)