Project 1

1. CREATE DATABASE ecommerce;

2. Imported the csv file in MySQL.

3. DESC users_data;

4. SELECT * FROM users_data LIMIT 100;

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

6. SELECT max(socialNbFollowers) FROM users_data WHERE gender = 'F' OR 'M';

7. i)SELECT count(hasProfilePicture) FROM users_data WHERE type = 'user' AND hasProfilePicture = 'TRUE';

ii) SELECT count(hasAnyApp) FROM users_data WHERE type = 'user' AND hasAnyApp = 'TRUE';

iii) SELECT count(hasAndroidApp) FROM users_data WHERE type = 'user' AND hasAndroidApp = 'TRUE';

iV) SELECT count(hasIosApp) FROM users_data WHERE type = 'user' AND hasIosApp = 'TRUE';

8. SELECT country,COUNT(productsBought) FROM users_data WHERE productsBought > 0 GROUP BY country ORDER BY COUNT(productsBought) DESC;

9. SELECT country,COUNT(productsSold) FROM users_data WHERE productsSold > 0 GROUP BY country ORDER BY COUNT(productsSold);

10. SELECT country,max(productsPassRate) FROM users_data GROUP BY country ORDER BY max(productsPassRate) DESC LIMIT 10;

11. SELECT language,COUNT(type) Users FROM users_data WHERE type = 'user' GROUP BY language;

12. SELECT gender,productsWished FROM users_data WHERE gender = 'F' UNION SELECT gender,socialProductsLiked FROM users_data WHERE gender = 'F';

13. SELECT type,gender,productsSold FROM users_data WHERE gender = 'M' UNION SELECT type,gender,productsBought FROM users_data WHERE gender = 'M';

14. SELECT country,max(productsBought) FROM users_data;

15. SELECT country,productsSold FROM users_data WHERE productsSold = '0' LIMIT 10;

16. SELECT type,daysSinceLastLogin FROM users_data ORDER BY daysSinceLastLogin ASC LIMIT 110 ;

17. SELECT COUNT(gender) FROM users_data WHERE NOT daysSinceLastLogin<=100 AND gender = 'F';

18. SELECT country,COUNT(gender) FROM users_data WHERE gender = 'F' GROUP BY country;

19. SELECT country,COUNT(gender) FROM users_data WHERE gender = 'M' GROUP BY country;

20. SELECT country,gender,avg(productsSold),avg(productsBought) FROM users_data WHERE gender = 'M' GROUP BY country;