« previous next »

Author Question: Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) write the standard SQL ... (Read 23 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?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

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

The nurse is using Standard Precautions to draw blood. The nurse is using Standard Precautions to draw blood.
Important Human Viral Table Important Human Viral Table
Standard Laboratory Lipid Profiles Standard Laboratory Lipid Profiles
Cumulative Standard Normal Distribution Cumulative Standard Normal Distribution
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 ...
table table
Video: Introduction to Eating Disorders

For a complete list of videos, visit our video library