« previous next »

Author Question: In Oracle, the statement used to calculate the number of clients, labeled Zip Clients, from each ... (Read 88 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 heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

The eight α-helical segments (shown here as cylinders) are labeled A through H The eight α-helical segments (shown here as cylinders) are labeled A through H
Skin testing. Note the spot labeled H, which is the positive histamine control, and the spot labeled ... Skin testing. Note the spot labeled H, which is the positive histamine control, and the spot labeled ...
How to calculate compound interest (Part 2) How to calculate compound interest (Part 2)
Drawings depicting mitosis in an animal cell with a diploid number of 4 Drawings depicting mitosis in an animal cell with a diploid number of 4
Calculate ΔG° Calculate ΔG°
Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ... Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ...
Video: Skin Cancer

For a complete list of videos, visit our video library