« previous next »

Author Question: In Oracle, the statement used to calculate the number of clients, labeled Zip Clients, from each ... (Read 66 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?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

How to calculate the probability of complementary events How to calculate the probability of complementary events
Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2. Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2.
Calculate the number of sodium ions in 0.375moles of Na2CO3.10H20 Calculate the number of sodium ions in 0.375moles of Na2CO3.10H20
What mass of sulfur hexafluoride, SF6, has the same number of fluorine atoms as 25.0 g of ... What mass of sulfur hexafluoride, SF6, has the same number of fluorine atoms as 25.0 g of ...
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 ...
Determination of the Number of Polygenes (n) Determination of the Number of Polygenes (n)
Video: The Krebs Cycle Animation

For a complete list of videos, visit our video library