SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Giohang 
(
    magh INTEGER PRIMARY KEY AUTOINCREMENT,
    masp INTEGER,
    makh TEXT ,
    mahang INTEGER ,
    tongtien INTEGER NOT NULL,
    ngay DATE,
    soluong INTEGER NOT NULL
);
✓
insert into Giohang values
(1,	1,	'a',	1,	2000,	'2023/11/20 11:43:01',	1),
(2,	2,	'a',	1,	2200,	'2023/11/20 11:43:01',	1);
✓
select *
from Giohang


magh
masp
makh
mahang
tongtien
ngay
soluong


1
1
a
1
2000
2023/11/20 11:43:01
1

2
2
a
1
2200
2023/11/20 11:43:01
1


SELECT SUM(tongtien) AS doanhthu 
FROM Giohang 
WHERE ngay >= '2023/11/01' AND ngay < '2023/11/21';


doanhthu


4200


SELECT SUM(tongtien) AS doanhthu 
FROM Giohang 
WHERE ngay >= '2023/11/01 00:00:00' AND ngay <= '2023/11/20 23:59:59';


doanhthu


4200