Project 1
1. created schema ecommerce
2. Imported CSV file into excel.
3. Ran SQL command to see structure of table.
4. SELECT * FROM ecommerce.users_data
LIMIT 100;
5. Distinct values exist in table for field country is 16 and language is 5.
6. Male users have 57 users and female users have 157 users
7.
- Uses Profile Picture in their Profile = 60
- Uses Application for Ecommerce platform = 17
- Uses Android app = 4
- Uses ios app = 13.
8. Total number of buyers for each country and sort the result in descending order of total number of buyers
9. Total number of sellers for each country and sort the result in ascending order of total number of sellers.
10. Top 10 countries having maximum products pass rate.
11. number of users on an ecommerce platform for different language choices
12. Choice of female users about putting the product in a wishlist or to like socially on an ecommerce platform.
13. Choice of male users about being seller or buyer.
14. Country is having maximum number of buyers
15. 10 countries having zero number of sellers.
16. Top 110 users who have used ecommerce platform recently.
17. Number of female users those who have not logged in since last 100 days.
18. Female users of each country at ecommerce platform.
19. Male users of each country at ecommerce platform.
20. Average number of products sold and bought on ecommerce platform by male users for each country.