Project 1

USE ECOMMERCE;
SELECT * FROM USERS_DATA
-- 3
desc USERS_data;
-- 4
select * from USERS_data limit 100;
-- 5
select count(distinct country) distinct_country , count(distinct language) distinct_language from USERS_data;
-- 6
select gender,sum(socialNbFollowers) followers from USERS_data group by gender;
-- 7A
select count(*) total_users_with_prfile_picture from USERS_data where hasProfilePicture='True';
-- 7B
select count(*) total_users from USERS_data where hasAnyApp='True';
-- 7C
select count(*) total_users from USERS_data where hasAndroidApp='True';
-- 7D
select count(*) total_users from USERS_data where hasIosApp='True';
-- 8
select country ,sum(productsBought) Total_buyers from USERS_data group by country order by sum(productsBought) desc;
-- 9
select country ,avg(productsSold) Total_Sellers from USERS_data group by country order by avg(productsSold) asc;
-- 10
select country,sum(productsPassRate) Products_Pass_Rate from USERS_data group by country order by sum(productsPassRate) desc limit 10;
-- 11
select language,count(*) Users from USERS_data group by language;
-- 12
select gender,sum(productsWished) ProductsWished , sum(socialProductsLiked) ProductsLiked from USERS_data where gender='F';
-- 13
select gender,sum(productsSold) Products_Sold , sum(productsBought) Products_Bought from USERS_data where gender='M';
-- 14
select country , sum(productsBought) ProductsBought from USERS_data group by country order by sum(productsBought) desc limit 1;
-- 15
select country, (productsSold) from USERS_data where productsSold=0 group by country limit 10;
-- 16
select identifierHash,gender, daysSinceLastLogin from USERS_data order by daysSinceLastLogin asc limit 110;
-- 17
select gender,count(daysSinceLastLogin) No_of_femaleUsers from USERS_data where gender='F' and daysSinceLastLogin > 100;
-- 18
select gender,country,count(*) No_of_FemaleUsers from USERS_data where gender='F' group by country order by country asc;
-- 19
select gender,country,count(*) No_of_maleUsers from USERS_data where gender='M' group by country order by country asc;
-- 20
select country,gender,avg(productsSold) , avg(productsBought) from USERS_data where gender='M' group by country order by country asc;