code a MySQL statement to display the number of sales orders.
Referring to Appendix A below, code a MySQL statement to display the number of sales orders.
APPENDIX A – Table definitions and initializations
-- MySQL script to initialize a MySQL
-- customer, detail, item, salesorder
--
DROP DATABASE IF EXISTS finaldb;
CREATE DATABASE finaldb;
USE finaldb;
CREATE TABLE customer (
c_num varchar(16),
c_name varchar(128)
);
CREATE TABLE detail (
d_onum varchar(16),
d_inum varchar(16),
d_qty int
);
CREATE TABLE item (
i_num varchar(16),
i_name varchar(128),
i_price decimal(9,2),
i_qty int
);
CREATE TABLE salesorder (
s_num varchar(16),
s_cnum varchar(16),
s_date date
);
INSERT INTO customer VALUES
('c101','Sam Paint'),
('c102','Ramon Hardware'),
('c103','Li Auto');
--
INSERT INTO detail VALUES
('s201','i301',21),
('s201','i302',22),
('s202','i302',23),
('s202','i303',24),
('s203','i303',25),
('s203','i304',26);
--
INSERT INTO item VALUES
('i301','Doormat',6.00,80),
('i302','Carpet',16.00,81),
('i303','Air conditioner',160.00,82),
('i304','Microwave',60.00,83);
--
INSERT INTO salesorder VALUES
('s201','c101','2020-3-11'),
('s202','c101','2020-3-12'),
('s203','c102','2020-3-13');
--
-- end of script
--
Step by step
Solved in 2 steps
