Question: Write a script that uses variables to get ( 1 ) the count of all the invoices in the Invoices table that have a balance

Write a script that uses variables to get (1) the count of all the invoices in the Invoices table that have a balance due and (2) the sum of the balances due for all those invoices. If that total balance due is greater than or equal to 50,000, the script should display a message like this: Number of unpaid invoices is 40. Total balance due is $66,796.24. Otherwise, the script should display this message: Total balance due is less than $50,000.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Good morning need some help with the following PL/SQL questions 1. Write a pseudocode (series of steps to create the code see my examples in Canvas) for a program to ask the user for a measurement in...

Q:

4 2 8 perspective using the techniques preseful, and less susceptible ys couripts that are more general, more use solve problems that calion, you ' be solved using any other technique. In the next...

Q:

Each of the scripts that you create in the following exercises should use the same general structure as the script presented in figure 1 3 - 1 in the book ( given as Appendix at end of this document,...

Q:

database management 2 1. (15) Write a script that uses three variables to store (1) the count of distinct orders made in the Orders table (2) the total amount of sales sales means the price of the...

Q:

1. (15) Write a script that uses three variables to store (1) the count of distinct orders made in the Orders table (2) the total amount of sales (sales means the price of the item with discount...

Q:

DATABASES BELOW: CREATE TABLE Categories ( CategoryID INT PRIMARY KEY IDENTITY, CategoryName VARCHAR(255) NOT NULL UNIQUE ); CREATE TABLE Products ( ProductID INT PRIMARY KEY IDENTITY, CategoryID INT...

Q:

Question is as follow: Database Schema: /* Murach Chapter 13 Figure 13-4 A SQL Script that Uses Variables*/ DECLARE max invoice total NUMBER(9,2); -Variable of the same type as invoice_total column...

Q:

write an sql query for the following questions 4. Write a script that uses two variables to store (1) the count of all of the instructors in the Instructors table and (2) the average annual salary...

Q:

Write a script that uses dynamic SQL to return a single column that represents the number of rows in the first table in the current database. The script should automatically choose the table that...

Q:

CIS 2 7 6 DB Module 8 Assignment 1 . Write a select statement based on the InvoiceTotal column of the Invoices table: - Use the CAST function to return the first column as an integer value. Name it...

Q:

Over the past 10 years, the average inflation rate in the United States was 1.8 percent per year. Due to large government deficits related to COVID and projected deficits for new proposed social...

Q:

For the circuit shown in the figure, I = 0.50 A and R = 12 . What is the value of the emf ? The answer is 24 V, but I don't understand how this is the answer. The two resistors measuring 2R each, are...

Q:

Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are: January 13,140 February 12,300 March 15,075 The variable overhead rate is $0.70 per...

Q:

Why are business loans not covered by Truth in Lending? What is covered under TIL? What special challenges do Internet applicants present?