« previous next »

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

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t
With the research technique called brainbow, each neuron is labeled with a different color, ... With the research technique called brainbow, each neuron is labeled with a different color, ...
How to calculate mortgage payments (Question 1 of 2) How to calculate mortgage payments (Question 1 of 2)
How to calculate simple interest (Part 5; r = I/Pt) How to calculate simple interest (Part 5; r = I/Pt)
Calculate the atomic mass of element Calculate the atomic mass of element
Number writing practice 1-30 kindergarten Number writing practice 1-30 kindergarten
Video: System organization - PPM system types (Somatic, Autonomic & Enteric) and Reflex arc types

For a complete list of videos, visit our video library