Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.

Q: This is a database system question regarding SELECT: Which of the following statements is true for…

A: The above question is solved in step 2:-

Q: Topic: SQL StoredProc Create a stored proc that returns all the students from schools with revenue…

A: Let's see the answer

Q: in sql ,create  a  program that prompts the user for a number. This number will be top (cap) number.…

A:

Q: table name: Accounts columns: account_num char(9) which is the primary key name varchar (20)…

A: SQL: CREATE TABLE Accounts ( account_num char(9) PRIMARY KEY, namevarchar(20), balance double );…

Q: reate a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is…

A: ANSWER:-

Q: Question 41: Match each reference or formula to its best description. =$A$6 =$B7…

A: =$A$6 =$B7 =SUM(AVERAGE(A1:!6), B7)       Absolute cell…

Q: Which of the following statements about the SELECT operation in SQL are true? [Select all that…

A: Solution : a) A WHERE clause is always required within a SELECT statement. Answer : False Select…

Q: A computer store uses a database to track inventory. The database has a table named Inventory , with…

A: Import necessary modules. The following line imports the sqlite3 module, which is a Python module…

Q: SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride",…

A: Your SQL code contains error related to function datediff.

Q: 5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum…

A: Max Function: It returns the maximum from the range of values. Syntax: MAX(number1, number2, ....)…

Q: 1. Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the…

A: A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over…

Q: File Name: Surname_MP8.m Problem Statement: Based on an automobile's model year and weight the state…

A: ANSWER;-

Q: Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then…

A: here i mentioned PL/SQL small two programs for given problem. also handled NO_DATA_FOUND and…

Q: Create a function in your own database that takes two parameters: A year parameter A month…

A: Database: A database is a set of data that has been arranged for easy access and management. To…

Q: Refer to the given SQL statement. SELECT PROONUM, PROONAME FROM PRODUCT; Which line designates a…

A: Given Table : PRODUCT Given Table attributes : PROONUM PROONAME

Q: Write the following PSM functions or procedures a) Take a price as argument and return the model…

A: Sample data:- The sample data for relations of question 1. These data are not used tocalculate…

Q: MS SQL SERVER   Write a statement to create a stored procedure named Find_Contact based on the…

A: ANSWER:-

Q: AL Distributors would like to know the number of months between the current date and the order date…

A: According to the Question below the Solution:

Q: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: I have answered this question in step 2.

Q: 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer…

A: Table "CUSTOMER": -- Table structure for table 'customer' CREATE TABLE customer ( CUST_ID INT…

Q: start end 1 8 6

A: -- sql-- select start only if x1 = x2 - 1 is satisfied-- select end as max if x2 = x1 + 1 is…

Q: In cell N3, enter a formula using the IF function and structured references as follows to determine…

A: The solution for the above-given question is given below:

Q: Create a metric distant conversion program(PL/SQL) Ask user three questions and collect them with &…

A: Please refer to the following steps for the complete solution to the problem above.

Q: 1) Write the SQL code that will create the table structure for a table named EMP. This table is a…

A: For auto generated id's we have to start from 101 and increment by 1 For checking JOB_CODE we can…

Q: 10. Please write a stored function named fHW_10_xxxx () which will return the total payment amount…

A: Solution: Considering the name of the schema(database) is student_db. MySQL query for creating…

Q: USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two…

A: sql select statement for above question is shown in step2

Q: Part I: Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the…

A: A stored procedure is a  program  that you can  create in the Database and also it  have different…

Q: Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped…

A: The task at hand involves using Excel's Index and math functions to populate a table displaying the…

Q: 17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine',…

A: Using self join between these two table we will get the results for George and Lorraine and to…

Q: PL/SQL Question I need to build pl/sql block that prompts a user for the number of visitors each…

A: Answers:- Here's a sample PL/SQL block that prompts the user for the number of visitors for the past…

Q: B See Balance //prints current balance D Make Deposit //get deposit amount from user and adds…

A: The program should ask the user to enter the balance: 4 choices: balance, deposit, withdrawal, Exit…

Q: Write dynamic SQL statements: a) Based on controls on the main search screen, write SQL statement to…

A: a) write dynamic SQL statements: a)Based on the controls of main search screen, write SQL statement…

Q: On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching…

A: The excel formula  is used here to calculate the desire result,  the excel formula in cell J3 . In…

Q: Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a…

A: Database:         An organized group of data that can be electronically stored and retrieved is…

Q: Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber,…

A: Below is the required query:

Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…

A:

Q: Question 7 To find out what functions you have created, use the following SQL query: select…

A: Given a sql query and we should find whether the given SQL query find out what funtions you have…

Q: Which of the following options represent a function that is entered in the highlighted cells to…

A: Answer: a) =SUMPRODUCT((A10:A13=A16),(B10:B13=B16),C10:C13,D10:D13)

Q: SQL code for:  Create a stored procedure “setRelocationFee” to set the relocation fee for a given…

A: In this have to create a stored procedure “setRelocationFee".

Q: Adjust the following information so that 1) all users on the system are able to run the SQL…

A: SUMMARY: -Hence, we set the code.