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

kaid0807

  • Hero Member
  • *****
  • Posts: 515
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
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


 

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?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

For a complete list of videos, visit our video library