« previous next »

Author Question: Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) write the standard SQL ... (Read 51 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 most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Juan Gris, The Table. Juan Gris, The Table.
Mobilize the rib cage. Redrape to cover the chest, and stand to one side of the table. Place your ... Mobilize the rib cage. Redrape to cover the chest, and stand to one side of the table. Place your ...
How to quickly determine the maximum or minimum value of a quadratic equation in standard form How to quickly determine the maximum or minimum value of a quadratic equation in standard form
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 ...
Write equilibrium constant expressions for the following reactions in terms of concentration: Write equilibrium constant expressions for the following reactions in terms of concentration:
Table - Correlation Analysis Table - Correlation Analysis
Video: Interview with Person who has Panic Attacks

For a complete list of videos, visit our video library