SQL-dataanalytics-1/sql dataanlysis code.sql at main · vaixnv10/SQL-dataanalytics-1 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
CREATE DATABASE DataAnalyticsProject;
USE DataAnalyticsProject;
CREATE TABLE Orders (
    OrderID VARCHAR(20),
    Date DATE,
    CustomerID VARCHAR(20),
    Product VARCHAR(50),
    Quantity INT,
    UnitPrice DECIMAL(10,2),
    ShippingAddress VARCHAR(100),
    PaymentMethod VARCHAR(30),
    OrderStatus VARCHAR(30),
    TrackingNumber VARCHAR(30),
    ItemsInCart INT,
    CouponCode VARCHAR(30),
    ReferralSource VARCHAR(30),
    TotalPrice DECIMAL(10,2)
);
DESCRIBE Orders;
show databases;
SELECT * FROM Orders;
SELECT COUNT(*) AS TotalOrders
FROM Orders;
SELECT Product, Quantity, TotalPrice
FROM Orders;
select *
from orders
where TotalPrice >1000;
select orderID, Product, TotalPrice
from orders
order by TotalPrice DESC;
SELECT Product,
COUNT(*) AS NumberOfOrders
FROM Orders
GROUP BY Product;
SELECT COUNT(*) AS TotalOrders
FROM Orders;
SELECT SUM(TotalPrice)
FROM Orders;
SELECT Product,
SUM(Quantity)
FROM Orders
GROUP BY Product;
SELECT Product,
AVG(UnitPrice)
FROM Orders
GROUP BY Product;
SELECT *
FROM Orders
WHERE CouponCode IS NOT NULL;
SELECT *
FROM Orders
ORDER BY TotalPrice DESC;
SELECT *
FROM Orders
ORDER BY Date DESC;
SELECT AVG(TotalPrice)
FROM Orders;
SELECT MAX(TotalPrice)
FROM Orders;
select min(totalprice)
from orders;
SELECT ReferralSource,
COUNT(*)
FROM Orders
GROUP BY ReferralSource;
SELECT OrderStatus,
COUNT(*)
FROM Orders
GROUP BY OrderStatus;
SELECT PaymentMethod,
SUM(TotalPrice)
FROM Orders
GROUP BY PaymentMethod;
SELECT Product,
SUM(TotalPrice)
FROM Orders
GROUP BY Product
HAVING SUM(TotalPrice)>20000;
SELECT *
FROM Orders
ORDER BY TotalPrice DESC
LIMIT 10;