Project 1

create database ecommerce;

process is given.

use ecommerce;
select * from user;

select * from ecommerce.user limit 100;

select count(distinct language) as lang, count(distinct country) as country from ecommerce.user;

select gender,sum(socialNbFollowers) as follower from ecommerce.user group by gender;

select count(hasProfilePicture) as users from ecommerce.user where hasProfilePicture = 'true';
select count(hasAnyApp) as users from ecommerce.user where hasAnyApp = 'true';
select count(hasAndroidApp) as users from ecommerce.user where hasAndroidApp = 'true';
select count(hasIosApp) as users from ecommerce.user where hasIosApp = 'true';

select count(productsBought) buyers, country from ecommerce.user where productsBought != 0 group by country order by country desc;

select count(productsSold) seller, country from ecommerce.user where productsSold != 0 group by country order by country asc;

select count(productsPassRate) passrate, country from ecommerce.user where productsPassRate != 0 group by country order by count(productsPassRate) desc limit 10;

select language,count(language) luser from ecommerce.user group by language;

select productsWished, socialProductsLiked from ecommerce.user where gender ='F' and productsWished !=0 union select productsWished, socialProductsLiked from ecommerce.user where gender ='F'and socialProductsLiked !=0;

select productsSold, productsBought from ecommerce.user where gender ='M' and productsSold !=0 union select productsSold, productsBought from ecommerce.user where gender ='M'and productsBought !=0;

select country, count(productsBought) buyers from ecommerce.user group by country order by count(productsBought) desc limit 1;

Select country from ecommerce.user where productsSold = 0 group by country limit 10;

select daysSinceLastLogin from ecommerce.user order by daysSinceLastLogin asc limit 110;

select count(gender) FEMALE from ecommerce.user where gender ='F' and daysSinceLastLogin >=100;

select count(gender) FEMALE, country from ecommerce.user where gender ='F' group by country;

select count(gender) MALE, country from ecommerce.user where gender ='M' group by country;

select avg(productsSold) avgsold, avg(productsBought) avgbought, gender, country from ecommerce.user where gender ='M' group by country;