Question: Using the SQL , perform the following Data Mining scenarios and you will need to work with the tables:Customer, Sales, Products Display the name of

Using the SQL , perform the following Data Mining scenarios and you will need to work with the tables:Customer, Sales, Products

Display the name of all customers who live in a city that contains the letter

Display the name of all customers who live in a city that contains the letter "O" within the City's name Building on the output of the first query, locate all products that contain the word "Bookcase" as part of the ProductName Your final output should contain: CustomerName, City, State, Category, SubCategory, ProductName

Step by Step Solution

★★★★★

3.45 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To perform the data mining scenarios you described using SQL with the Customer Sales and Products ta... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

(a) Denmark Cookie Co is looking to fund a new factory and production facilities to produce cakes for 12 years with debt financing. Explain why loan covenants are imposed on the borrowings of this...

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...

If the current spot rate is 2.10 (HC/FC) and the government undertakes policies to depreciate the currency 16%, what is the new spot rate? Note: 2.10 * 1.16 is not the right formula. Based on this,...

Presented are a number of values taken from compound interest tables involving the same number of periods and the same rate of interest? Indicate what each of these four values represents. (a)...

OBJECTIVE 5 List the marketing management functions, including the elements of a marketing plan, and discuss the importance of measuring and managing return on marketing investment. Managing the...

In the two-class priority queueing model of Section 8.6.2, what is WQ? Show that WQ is less than it would be under FIFO if E[S1] E[S2].

1. How were financial markets likely to respond to President Carters lecture? Explain. 2. At the time President Carter made his remarks, the inflation rate was running at about 10% annually and...

PARTE I: Bonos por pagar A continuacin, se presenta una porcin de la tabla de amortizacin relacionada con la emisin de unos bonos de 20 aos de la Empresa Zeroz (NO TIENE QUE COMPLETAR LA TABLA). Los...

a. Use the CAPM to compute the required rate of return on common equity capital for Starbucks. b. Using your projected financial statements from Case 10.1 for Starbucks, begin with projected net cash...

11. The journal entry to record the return of $500 of themerchandisepurchased in Question #10 to the supplier is:a. Accounts Payable---------------------------------------------- 565HST Recoverab 2...

Q1: What is deferred tax, and how is it accounted for? Q2: Explain the difference between tax avoidance and tax evasion.

Q1: What is the purpose of an audit, and what are the types of audits? Q2: What are internal controls, and why are they important in the auditing process?

Q1: What is managerial accounting, and how does it differ from financial accounting? Q2: What are some common techniques used in managerial accounting?

Q1: What are financial ratios, and why are they important? Q2: Explain the difference between liquidity ratios and profitability ratios with examples.

Q1: What is the purpose of budgeting in a business? Q2: What is the difference between static and flexible budgets?

Design Project 2 0 2 4 LL Design Statement 1 The Design Design a process to produce 2 0 , 0 0 0 tons per year of monochlorobenzene together with not less than 2 , 0 0 0 tons per year of...

Refer to the Conservation Ecology (Dec. 2003) study of the causes of forest fragmentation, presented in Exercise 2.166 (p. 97). Recall that the researchers used advanced high-resolution satellite...

If the CACHE or NOCACHE options arent included in the CREATE SEQUENCE command, which of the following statements is correct? a. Oracle 11g generates 20 integers automatically and stores them in...

Define a one-to-many relationship.

How is a user password assigned in Oracle 11g?

Females and males are very similar to each other. But one way they differ is that females are more physically aggressive than males. males are more democratic than females in their leadership roles....

Surveys show that about 40 percent of Americans believe society should not accept same-sex marriages. Yet, acceptance of nonheterosexual orientation is increasing, especially among young people. Why...

In describing the sexual response cycle, Masters and Johnson noted that a plateau phase follows orgasm. men experience a refractory period during which they cannot experience orgasm. the feeling that...