Project

1 -- create database 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 distinctcountries, COUNT(DISTINCT language) AS distinctlanguages
FROM users_data;

6 -- select gender,Max(socialNbFollowers) as maximumfollowers from users_data group by gender;

7 -- a -- select count(hasProfilePicture) uses_Profile_Picture from users_data where hasProfilePicture="True";
b -- select count(*) Application_for_Ecommerce_platform from users_data;
c -- select count(hasAndroidApp) uses_Android_App from users_data where hasAndroidApp="True";
d -- select count(hasIosApp) uses_Ios_App from users_data where hasIosApp="True";

select * from users_data;

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;