# Problems 17–21 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = 'TN' ORDER BY V_NAME; Assume that 10,000 vendors are distributed as shown in Table P11.18. What percentage of rows will be returned by the query? TABLE P11.18 STATE NUMBER OF VENDORS AK 15 AL 55 AZ 100 CA 3244 CO 345 FL 995 GA 75 HI 68 IL 89 IN 12 KS 19 KY 45 LA 29 MD 208 MI 745 MO 35 MS 47 NC 358 NH 25 NJ 645 NV 16 OH 821 OK 62 PA 425 RI 12 SC 65 SD 74 TN 113 TX 589 UT 36 VA 375 WA 258

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Chapter
Section

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 11, Problem 18P
Textbook Problem
21 views

## Problems 17–21 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE  FROM VENDOR WHERE V_STATE = 'TN' ORDER BY V_NAME; Assume that 10,000 vendors are distributed as shown in Table P11.18. What percentage of rows will be returned by the query?TABLE P11.18 STATE NUMBER OF VENDORS AK 15 AL 55 AZ 100 CA 3244 CO 345 FL 995 GA 75 HI 68 IL 89 IN 12 KS 19 KY 45 LA 29 MD 208 MI 745 MO 35 MS 47 NC 358 NH 25 NJ 645 NV 16 OH 821 OK 62 PA 425 RI 12 SC 65 SD 74 TN 113 TX 589 UT 36 VA 375 WA 258

### Explanation of Solution

Given:

Total number of vendors =10,000

Analysis of the given query:

In the given query the attributes code, name, contact, state are selected from the table “vendor” whose condition criteria is based on the state whose value is “TN” and which displays the name using ORDER BY clause.

Analysis of the table:

From the data given in the table the query that matches condition of the given criteria whose state value is “TN” will display around “113” vendors from the total of “1000” vendors...

### Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

#### The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Find more solutions based on key concepts
What is data scrubbing?

Fundamentals of Information Systems

Look up the furnace size and the size of the air-conditioning unit in your own home or apartment. Investigate t...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Explain the difference between a LAN and a WAN.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

What is the NEC definition of a qualified person?

EBK ELECTRICAL WIRING RESIDENTIAL

Compute the nominal shear strength of an M107.5 of A572 Grad 65 steel.

Steel Design (Activate Learning with these NEW titles from Engineering!)

What is contained in an NFC card? (395)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What changes can be made to successfully make a weld in a poorly fitted joint?

Welding: Principles and Applications (MindTap Course List)