« previous next »

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

There are 60,000 miles of blood vessels in every adult human.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

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.
Mayan Number Mayan Number
Prove the argument using two column proof number 5 only Prove the argument using two column proof number 5 only
Number of Chromosomes in Selected Organisms Number of Chromosomes in Selected Organisms
A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ... A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ...
Number line (real numbers) Number line (real numbers)
Video: Dissociative Disorders (Part 3)

For a complete list of videos, visit our video library