Chapter 7, Problem 27P

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 “CUSTOMER” table:

CREATE TABLE CUSTOMER (CUS_CODE INTEGER PRIMARY KEY, CUS_LNAME VARCHAR(20), CUS_FNAME VARCHAR(20), CUS_INITIAL VARCHAR(20), CUS_AREACODE VARCHAR(20), CUS_PHONE VARCHAR(20), CUS_BALANCE Decimal(5, 2));

Query to insert values into “INVOICE” table:

INSERT INTO CUSTOMER VALUES (10010, 'Ramas', 'Alfred','A', 615, 844-2573, 0);

INSERT INTO CUSTOMER VALUES (10011, 'Dunne', 'Leona', 'K',  713, 894-1238, 0);

INSERT INTO CUSTOMER VALUES (10012, 'Smith','Kathy', 'W',  615, 894-2285, 345.86);

INSERT INTO CUSTOMER VALUES (10013, 'Olowski', 'Paul', 'F',  615, 894-2180, 536.75);

INSERT INTO CUSTOMER VALUES (10014, 'Orlando', 'Myron', '',  615, 222-1672, 0);

INSERT INTO CUSTOMER VALUES (10015, 'OBrian', 'Amy','B',  713, 442-3381, 0);

INSERT INTO CUSTOMER VALUES (10016, 'Brown', 'James', 'G',  615, 297-1228, 221.19);

INSERT INTO CUSTOMER VALUES (10017, 'Williams', 'George', '',  615, 290-2556, 768.93);

INSERT INTO CUSTOMER VALUES (10018, 'Farriss','Anne', 'G',  713, 382-7185, 216.55);

INSERT INTO CUSTOMER VALUES (10019, 'Smith', 'Olette', 'K',  615, 297-3809, 0);