« previous next »

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

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

The Periodic Table The Periodic Table
Example of the Table of Drugs and Chemicals. Example of the Table of Drugs and Chemicals.
Assisting the patient to transfer from the bed or examining table to a wheelchair. Assisting the patient to transfer from the bed or examining table to a wheelchair.
Periodic table of the elements Periodic table of the elements
table table
APA Table - SPSS APA Table - SPSS
Video: Appendicitis Animation

For a complete list of videos, visit our video library