« previous next »

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

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

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?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

skull labeled skull labeled
Skull Transverse Superior View Labeled Skull Transverse Superior View Labeled
In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh
Calculate the given limits eliminating zero denominator algebraicilly Calculate the given limits eliminating zero denominator algebraicilly
Ho to calculate the ATP of a 12-Carbon fatty acid, beta oxidation Ho to calculate the ATP of a 12-Carbon fatty acid, beta oxidation
Locate the following places by reference number on the map:Key Locales of Political, Economic, ... Locate the following places by reference number on the map:Key Locales of Political, Economic, ...
Video: Pores and Ion Channels

For a complete list of videos, visit our video library