« previous next »

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

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

skull labeled skull labeled
Young adulthood brings the greatest number of role transitions and highest levels of demands than ... Young adulthood brings the greatest number of role transitions and highest levels of demands than ...
Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ... Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ...
The Location and Number of Farms in the United States, 2012 The Location and Number of Farms in the United States, 2012
How mitosis maintains the chromosome number. How mitosis maintains the chromosome number.
Gray Morris's Calculate with Confidence, Canadian Edition, 2nd Edition Gray Morris's Calculate with Confidence, Canadian Edition, 2nd Edition
Video: Types of Transport - Uniport, Antiport and Symport (Glucose and Na+K+ Transporters)

For a complete list of videos, visit our video library