« previous next »

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

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?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Height and weight table Height and weight table
a) Lunge with your legs open to the table. b) Avoid lunging with your legs close to table. a) Lunge with your legs open to the table. b) Avoid lunging with your legs close to table.
Checklist for Choosing a Massage Table Checklist for Choosing a Massage Table
Some Standard Shapes of Greek Vessels Some Standard Shapes of Greek Vessels
ANOVA Table ANOVA Table
Write the following in standard form Write the following in standard form
Video: Epinephrine/NE (heart rate, altered blood flow, glycogenolysis & bronchodilation)

For a complete list of videos, visit our video library