
Concept explainers
“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);

Want to see the full answer?
Check out a sample textbook solution
Chapter 7 Solutions
Database Systems: Design Implementation & Management
- Describe three (3) Multiplexing techniques common for fiber optic linksarrow_forwardCould you help me to know features of the following concepts: - commercial CA - memory integrity - WMI filterarrow_forwardBriefly describe the issues involved in using ATM technology in Local Area Networksarrow_forward
- For this question you will perform two levels of quicksort on an array containing these numbers: 59 41 61 73 43 57 50 13 96 88 42 77 27 95 32 89 In the first blank, enter the array contents after the top level partition. In the second blank, enter the array contents after one more partition of the left-hand subarray resulting from the first partition. In the third blank, enter the array contents after one more partition of the right-hand subarray resulting from the first partition. Print the numbers with a single space between them. Use the algorithm we covered in class, in which the first element of the subarray is the partition value. Question 1 options: Blank # 1 Blank # 2 Blank # 3arrow_forward1. Transform the E-R diagram into a set of relations. Country_of Agent ID Agent H Holds Is_Reponsible_for Consignment Number $ Value May Contain Consignment Transports Container Destination Ф R Goes Off Container Number Size Vessel Voyage Registry Vessel ID Voyage_ID Tonnagearrow_forwardI want to solve 13.2 using matlab please helparrow_forward
- a) Show a possible trace of the OSPF algorithm for computing the routing table in Router 2 forthis network.b) Show the messages used by RIP to compute routing tables.arrow_forwardusing r language to answer question 4 Question 4: Obtain a 95% standard normal bootstrap confidence interval, a 95% basic bootstrap confidence interval, and a percentile confidence interval for the ρb12 in Question 3.arrow_forwardusing r language to answer question 4. Question 4: Obtain a 95% standard normal bootstrap confidence interval, a 95% basic bootstrap confidence interval, and a percentile confidence interval for the ρb12 in Question 3.arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning

