« previous next »

Author Question: Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) write the standard SQL ... (Read 58 times)

kaid0807

  • Hero Member
  • *****
  • Posts: 515
on: Jul 7, 2018
Given the table
 
  CUSTOMER(CustID, Name, PhoneNumber, AccountBalance)
 
  write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Question 2

Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of less work, standardized processing, and specialization among developers.
 
  Indicate whether the statement is true or false


juicepod

  • Sr. Member
  • ****
  • Posts: 310
Reply #1 on: Jul 7, 2018
Answer to Question 1

SELECT Name, PhoneNumber
FROM CUSTOMER
WHERE AccountBalance > 50;

Answer to Question 2

TRUE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

kaid0807

  • Hero Member
  • *****
  • Posts: 515
Reply #2 on: Jul 7, 2018
Thank you :)


juicepod

  • Sr. Member
  • ****
  • Posts: 310
Reply #3 on: Jul 7, 2018
Happy to help you


« previous next »
 

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Standard precaution guidelines. Additional guidelines/protocols may be utilized depending on the ... Standard precaution guidelines. Additional guidelines/protocols may be utilized depending on the ...
Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ... Finish with bilateral stroking to the entire back. Stand at head of the table with fingers pointing ...
Wet table and Vichy shower in a wet room. Wet table and Vichy shower in a wet room.
Look at Table 4.2.2. Consumers learn that the rubber ducks wear out batteries quickly. As a ... Look at Table 4.2.2. Consumers learn that the rubber ducks wear out batteries quickly. As a ...
8.The following table contains DNA-sequence information compiled by Marilyn Kozak (1987). The ... 8.The following table contains DNA-sequence information compiled by Marilyn Kozak (1987). The ...
SPSS TABLE TO APA FORMAT SPSS TABLE TO APA FORMAT
Video: Summary of glucose catabolism

For a complete list of videos, visit our video library