Question: how do i fix these codes Task 2.2.5. List all cust id's who do not have a phone containing a '6' in the last four

how do i fix these codes

Task 2.2.5. List all cust id's who do not have a phone containing a '6' in the last four digits. For example: Result cust_id A01 D04 E05 G07 H08 phone 555-1234 555-5050 555-7777

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Table 1. Compositions and Sales Prices of Different Cereals Cereal Max Vitamins % Min Protein % Min Fiber % Max Fat % Sales Price ($/package) Strong Fit 40% 20% 25% 20% 25% 8.1 Fun 30% 20% 15% 15%...

This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and Querying in Excel...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

1. When Algorithms Decide What You Pay YOU MAY NOT REALIZE IT, but every website you visit is created, literally, the moment you arrive. Each element of the page the pictures, the ads, the text, the...

Login to your Unik system and try the following at the Linux prompt [user@Loki user]s finger This gives a list of everyone currently logged into the syst [user Loki users finger robert Fulkerson...

The Final Project is to develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to a file, addition and...

Follow the instructions on the Joe Riley 2 file (click next at the bottom of this page) to prepare Joe's 2019 federal income taxes. You will find all of the 2019 tax forms that you will need at the...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Directions Using the tax software, complete the tax return, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering...

a. For the chi-squared test for equality of percentages, what do you conclude if the chi-squared statistic is larger than the value in the chi-squared table? b. What do you conclude if the...

Pace Western Crystal, Inc. has 10 million shares of common stock outstanding and 200,000 warrants. Each warrant entitles the holder to purchase 5 shares of common stock at a price of $15 per share....

Assuming P 0 , suppose that a population develops according to the logistic equation d P d t = 6 . 0 8 P - 6 . 0 0 0 L P 2 where t is measured in weeks. Answer the following questions. The carrying...

kettle K takes twice as long to boil the same amount of water as does kettle M. If M uses 400 kJ of energy to do the job, kettle K needs in kJ: a. 200 b. 400 c. 800 d. 1600 e. None of a, b, c and d

A car is driven 40 km east and 30 km north. the car finally drives 50 km NE True False

Calculate the mass of methane gas contained at 1500 psi and 88 F in a cylinder with volume of 2.5 cu ft. assume methane is ideal gas, then assume it is non-ideal gas and calculate the error? Repeat...

Calculate the specific gravity and the z-factor for the following gas mixture at pressure of 340 psia and temperature of 200 F: Component Mole Fraction Methane Ethane Propane Aregon 0.850 0.090 0.040...

Firm A has 10 million shares outstanding, currently trading at $5/share. They are worried about possible hostile acquisitions, so they adopt a poison pill that consists of call options that allow...

Describe a person whom you believe is a great leader

In the first half of the 20th century, whooping cough was a frequently occurring bacterial infection that often resulted in death, especially among young children. A vaccination for whooping cough...

For a combined ELISAWestern blot blood test for HIV positive status, the sensitivity is about 0.999 and the specificity is about 0.9999 (Gigerenzer 2002, pp. 124 , 126 ). a. Consider a high-risk...

Two TV commercials are developed for marketing a new product. A volunteer test sample of 200 people is randomly split into two groups of 100 each. In a controlled setting, Group A watches commercial...

Must a seasonal component be associated with the seasons (fall, spring, summer, winter) of the year? Provide an example of a seasonal effect that is not associated with the seasons of the year.

Tom and Hanks is a regional convenience store with locations in several small towns along the Mississippi River. The quarterly revenue for the store beginning with the first quarter of 2005 and...

Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. They are given here. a. Produce a time-series plot for these...