Project 1

3.USE ecommerce;

DESC ecommerce;

4.USE ecommerce;

SELECT * FROM ecommerce LIMIT 100;

5.USE ecommerce;

SELECT DISTINCT country,language FROM ecommerce;

6.USE ecommerce;

SELECT  COUNT(socialNbFollowers) FROM ecommerce WHERE gender = 'F';

SELECT  COUNT(socialNbFollowers) FROM ecommerce WHERE gender = 'M';

7.(a)USE ecommerce;

SELECT COUNT(*) FROM ecommerce WHERE hasProfilePicture LIKE 'TRUE';

(b)USE ecommerce;

SELECT COUNT(*) FROM ecommerce WHERE hasAnyApp LIKE 'TRUE';

(c)USE ecommerce;

SELECT COUNT(*) FROM ecommerce WHERE hasAndroidApp LIKE 'TRUE';

(d)USE ecommerce;

SELECT COUNT(*) FROM ecommerce WHERE hasIosApp LIKE 'TRUE';

8.USE ecommerce;

SELECT productsBought,country FROM ecommerce ORDER BY productsBought DESC;

9.USE ecommerce;

SELECT productsSold,country FROM ecommerce ORDER BY productsSold ASC;

10.USE ecommerce;

SELECT country,productsPassRate FROM ecommerce ORDER BY productsPassRate DESC LIMIT 10;

11.USE ecommerce;

SELECT COUNT(type) users,language FROM ecommerce GROUP BY language;

12.USE ecommerce;

SELECT productsWished,socialProductsLiked FROM ecommerce WHERE gender = 'F';

13.USE ecommerce;

SELECT productsSold,productsBought FROM ecommerce WHERE gender = 'M';

14.USE ecommerce;

SELECT country,MAX(productsBought) MaximumBuyers FROM ecommerce;

15.USE ecommerce;

SELECT country,productsSold FROM ecommerce WHERE productsSold = '0' LIMIT 10;

16.USE ecommerce;

SELECT identifierHash,daysSinceLastLogin FROM ecommerce ORDER BY daysSinceLastLogin DESC LIMIT 110;

17.USE ecommerce;

SELECT identifierHash,gender FROM ecommerce WHERE gender ='F' ORDER BY daysSinceLastLogin ASC LIMIT 100;

18.USE ecommerce;

SELECT DISTINCT(country),COUNT(type)users,gender FROM ecommerce WHERE gender = 'F' GROUP BY country;

19.USE ecommerce;

SELECT DISTINCT(country),COUNT(type)users,gender FROM ecommerce WHERE gender = 'M' GROUP BY country;

20.USE ecommerce;

SELECT

DISTINCT(country),type,gender,AVG(productsSold)Averageproductssold,AVG(productsBought)Averageproductsbought FROM ecommerce WHERE gender = 'M' GROUP BY country;