Project

1. create database if not exists ecommerce;
use ecommerce;
select *from users_data;
select count(*) from users_data;
3. desc users_data;
4. select *from users_data limit 100;

5. SELECT COUNT(DISTINCT country) AS distinct_countries, COUNT(DISTINCT language) AS distinct_languages
FROM users_data;

6. select gender,Max(socialNbFollowers) maximum_followers from users_data group by gender;

7. select count(hasProfilePicture) uses_Profile_Picture from users_data where hasProfilePicture="True";
select count(*) Application_for_Ecommerce_platform from users_data;
select count(hasAndroidApp) uses_Android_App from users_data where hasAndroidApp="True";
select count(hasIosApp) uses_Ios_App from users_data where hasIosApp="True";

8. select country,count(type) total_number_of_buyers from users_data where productsBought>=1 group by country order by total_number_of_buyers desc ;

9. select country,count(type) total_number_of_sellers from users_data where productsSold>=1 group by country order by total_number_of_sellers;

10. select country, Max(productsPassRate) maximum_rate from users_data group by country order by maximum_rate desc limit 10;

11. select language, count(type) users from users_data group by language order by users desc;

12. select gender, 'products wished' Choice, sum(productsWished) total from users_data where gender="F" union
select gender, 'Social pro like' choice, sum(socialProductsLiked) total from users_data where gender="F";

13. select gender, 'Buyer' Choice, sum(productsBought) total from users_data where gender="M" union
select gender, 'Seller' Choice, sum(productsSold) total from users_data where gender="M";

14. select country, count(type) MaxBuyers from users_data where productsBought>0 group by country order by MaxBuyers desc limit 1;

15. select country from users_data where productsSold=0 group by country limit 10;

16. select country,type,identifierHash,daysSinceLastLogin from users_data order by daysSinceLastLogin limit 110;

17. select gender, count(gender) TotalUser, daysSinceLastLogin from users_data where gender="F" and daysSinceLastLogin=100;

18. select country, count(gender) TotalFemaleUser from users_data where gender="F" group by country order by TotalFemaleUser desc ;

19. select country, count(gender) TotalMaleUser from users_data where gender="M" group by country order by TotalMaleUser desc;

20. select country,avg(productsBought) Average_No_of_productsBought, avg(productsSold) Average_No_of_productsSold from users_data where gender="M" group by country;