Chapter 7, Problem 9P

Program Plan Intro

“COUNT()” function:

In SQL, the “COUNT()” function will return the total number of rows in the table with satisfying the criteria mentioned in the “WHERE” clause.

Table creation:

Query to create “INVOICE” table:

CREATE TABLE INVOICE (INV_NUMBER INTEGER PRIMARY KEY, CUS_CODE INTEGER, INV_DATE DATE);

Query to insert values into “INVOICE” table:

INSERT INTO INVOICE VALUES (1001, 10014, '16-Jan-18');

INSERT INTO INVOICE VALUES (1002, 10011, '16-Jan-18');

INSERT INTO INVOICE VALUES (1003, 10012, '16-Jan-18');

INSERT INTO INVOICE VALUES (1004, 10011, '17-Jan-18');

INSERT INTO INVOICE VALUES (1005, 10018, '17-Jan-18');

INSERT INTO INVOICE VALUES (1006, 10014, '17-Jan-18');

INSERT INTO INVOICE VALUES (1007, 10015, '17-Jan-18');

INSERT INTO INVOICE VALUES (1008, 10011, '17-Jan-18');