« previous next »

Author Question: In Oracle, the statement used to calculate the number of clients, labeled Zip Clients, from each ... (Read 34 times)

fbq8i

  • Hero Member
  • *****
  • Posts: 527
on: Jul 7, 2018
In Oracle, the statement used to calculate the number of clients, labeled Zip Clients,
  from each zip code in states with at least three clients, would be __________.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the statement used to show all the different client zip codes, would be
  __________.
 
  Fill in the blanks with correct word


javimendoza7

  • Sr. Member
  • ****
  • Posts: 293
Reply #1 on: Jul 7, 2018
Answer to Question 1

Select zipcodes, Count(email) As 'Zip Clients' From client Group by zipcode Having Count(state) > 1

Answer to Question 2

Select Distinct zipcode From client


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Differences in the number and location of flagella. Differences in the number and location of flagella.
History of the number of observed sunspots during the last 250 years, which shows the ~11-year solar History of the number of observed sunspots during the last 250 years, which shows the ~11-year solar
How to calculate RRSP using the annuity formula How to calculate RRSP using the annuity formula
The Haploid Number of Chromosomes for a Variety of Organisms The Haploid Number of Chromosomes for a Variety of Organisms
Calculate the molar solubility of thallium(I) chloride in 0.30 M NaCl at 25°C. Ksp for TlCl is ... Calculate the molar solubility of thallium(I) chloride in 0.30 M NaCl at 25°C. Ksp for TlCl is ...
A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ... A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ...
Video: Nervous pathway to the Neuromuscular (NMJ)

For a complete list of videos, visit our video library