Project 1

all

https://skill-lync.com/student-projects/project-1-7863

1:create database ecommerce;

use ecommerce;

2:use ecommerce;

select count(*) from users_data;

/* (right click on ecommerce schema
-> Table Data import Wizard
-> Give path of the file
-> Next
-> choose options : Create a new table , select delete if exist -> next -> next) */

3:desc users_data;

4:select * from users_data limit 100;

5:select count(distinct country) country, count(distinct language) language from users_data;

6:select gender,sum(socialNBFollowers) from users_data group by gender;

7:select count(hasProfilePicture) Users_with_ProfilePicture from users_data where hasProfilePicture = 'True';

b:

Uses Application for Ecommerce platform
select count(hasAnyApp) Users_with_Anyapp from users_data where hasAnyApp = 'True';

8:select country,count(productsBought) Buyers from users_data group by country order by Buyers desc;

9:select country,count(productsSold) Sellers from users_data group by country order by Sellers asc;

10:select country from users_data group by country having max(productsPassRate) limit 10;

11:select language,count(language) from users_data group by language;

12:select sum(productsWished) ,sum(socialProductsLiked) from users_data where gender='F';

-- choice of ehr female users about putting the product in a wishlist or to like socially om an ecommerce platform is same.

13:select count(productsSold),count(productsBought) from users_data where gender='M';

-- choicr of male users about being seller or buyer is same.

14:

select country,max(productsBought) Max_no_of_buyers from users_data group by country order by max(productsBought) desc limit 1;
-- Belfique country is having maximum number of buyers.

15:select country , productsSold from users_data where productsSold=0 limit 10;

16:select * from users_data group by daysSinceLastLogin having min(daysSinceLastLogin) order by daysSinceLastLogin asc limit 110;

17:select count(type) from users_data where gender='F' and daysSinceLastLogin >= 100;

18:select country,count(gender) Female_users from users_data where gender='F' group by country;