« previous next »

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

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

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?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Osteon model labeled Osteon model labeled
Average Number of Hours Slept per Day by Various Mammalian Species Average Number of Hours Slept per Day by Various Mammalian Species
How to write any number in engineering notation How to write any number in engineering notation
How to multiply a complex number by its conjugate How to multiply a complex number by its conjugate
Calculate the velocity of the red rock after collision Angle measured counterclockwise from the ... Calculate the velocity of the red rock after collision Angle measured counterclockwise from the ...
Separation of variable number tandem repeat (VNTR) alleles after PCR amplification Separation of variable number tandem repeat (VNTR) alleles after PCR amplification
Video: Bone tissue types - compact and spongy

For a complete list of videos, visit our video library