create database account_receivable;
use account_receivable;
create table accounts_info(
 uuid varchar(32) primary key,
 pname varchar(32),
 income float,
 sale_date date,
 sale_num float,
 sale_price float,
 cost_price float);
insert into accounts_info(uuid,
pname,income,sale_date,
sale_num,sale_price,cost_price)
values('00002','产品b',1239.87,208.24,80.67,19.3,2.71),
('00001'
'产品a',1240.87,209.24,20201021,80.67,
19.3,2.71),('00003','产品c',8893.27,7653.59,20201019,
89.96,98.97,85.17),('00004','产品d',1171.03,686.7,20201011,
71.33,16.42),
('00005','产品e',1428.47,6324.22,20201025,55.85,25.58,113.24),
('00006','产品f',9519.28,2345.25,20201029,45.61,208.72,51.42),
('00007','产品g',

select*from accounts_info 
where income>1240;
select sale_num,sale_price,sale_date
from accounts_info
where sale_date between '2020-10-21'and'2020-10-26';