The SQL statement that would create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer is:
GET_CREDIT_LIMIT
SELECT CUST_ID 125
FROM FIRST_NAME, LAST_NAME, CREDIT_LIMIT
WHERE LAST_NAME ="Smith"
<h3>What is SQL?</h3>
This is an acronym that means Structured Query Language that is used in handling data in a database.
Hence, we can see that from the attached image, there is a table that contains the details of customers and their various data such as their first and last names, credit limits, address, etc, and the GET_CREDIT_LIMIT procedure is shown above.
Read more about SQL here:
brainly.com/question/25694408
#SPJ1
It takes a lot of time and effort to write the code for the same. It is very complex and difficult to understand. The syntax is difficult to remember. It has a lack of portability of program between different computer architectures.
Hope that helps
Answer:
customers = int(input("How many customers? "))
for i in range(customers):
name = input("Name of Customer " + str(i+1) + " ")
print("Oranges are $1.40 each.")
oranges = int(input("How many Oranges? "))
print("Apples are $.75 each.")
apples = int(input("How many Apples? "))
bill = oranges * 1.4 + apples * 0.75
print(name + ", you bought " + str(oranges) + " Orange(s) and " + str(apples) + " Apple(s). Your bill is $%.1f" % bill)
Explanation:
*The code is in Python.
Ask the user to enter the number of customers
Create a for loop that iterates for each customer. Inside the loop, ask the user to enter the name, number of oranges, number of apples. Calculate the bill. Print the name, number of oranges, number of apples bought and total bill
Answer:
the aspect that help you change the luminescence of your image is iframe
