« previous next »

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

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Step stool can help clients get onto and off of a high table. Step stool can help clients get onto and off of a high table.
Educate clients about products related to massage therapy and the clients’ health goals without ... Educate clients about products related to massage therapy and the clients’ health goals without ...
How to calculate present value (Question 2) How to calculate present value (Question 2)
Correlations between scores on a psychology test and number of boiled kumquats eaten per month Correlations between scores on a psychology test and number of boiled kumquats eaten per month
The distribution of the number of hours that a random sample of people spend doing chores per ... The distribution of the number of hours that a random sample of people spend doing chores per ...
The relationship between the number of stem cell divisions in the lifetime of a given tissue and the The relationship between the number of stem cell divisions in the lifetime of a given tissue and the
Video: Neurotransmission at chemical synapses & Excitory and inhibitory potentials

For a complete list of videos, visit our video library