which command would you use to determine the amount due from customer?
Q: Which cards do not have a price recorded. Display all fields in the same column order as defined in…
A: Answer: We have to print table based on data given . here we will use SQL query to print data. we…
Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…
A: The above question is solved in step 2 :-
Q: Owner Sims Haydon contacted the Colombia City (ID: 1) office and informed them that the monthly rent…
A: Kent drive problem Task: updating the montly rent for the property at Kent Drive
Q: List the customer number, customer last name, and customer first name of each customer that lives in…
A: A command to list the customer number, customer last name, and customer first name of each customer…
Q: In which clause the subquery can be used? Select one: a.FROM b.HAVING c.WHERE
A: Subquery meaning query within the query.
Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez
A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…
Q: mysql> select * from item_db; | item_code | item_name 2 B 8 10 33 85 200 500 9 6 rows in set (0.00…
A: The number of orders made for the item with code '200' directly from the provided item_db table.…
Q: What is the best way to create a basic condition?
A: The question is to write the way to create the basic condition. As it is related to computer science…
Q: Which command can you use to change the existing data in a table?
A: UPDATE command is used in Structured Query Language to change or modify the existing data in the…
Q: Create a view named INVOICE_TOTAL. It consists of the invoice number and invoice total for each…
A: The SQL Query is given below:
Q: Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.
A: The query to pull all columns for subscriptions that have been cancelled from the…
Q: 1. Which customers live in New Jersey? List each customer’s last name, first name, and state.
A: The solution is given in next step: Let's say that the table's name is Customer for the moment.
Q: Create a list of all of the customers' purchases, using the output from the previous command as a…
A: SQL query: Information Schema View Method is a method for viewing information schemas. The…
Q: Which of the following SQL commands lists the contents of a table named EMPLOYEE? LIST * FROM…
A: the answer is : SELECT * FROM EMPLOYEE
Q: Using the WHERE clause, filter the invoice table to find the invoices that were dated after March…
A: The question has been answered in step2
Q: 8. In the OrderItems table, display the minimum item_price with the alias shown. 2.49 1 rows…
A: Below is the complete solution with explanation in detail for the given question about writing query…
Q: In cell B20, enter a formula to calculate the number of clients the sales associate had with annual…
A: The solution to this task involves using the COUNTIFS function, which allows you to count the number…
Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…
A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…
Q: Use select statements to create queries that answer the following questions. Only provide the…
A: Queries: 1) SELECT ItemDescription, Price FROM Flower WHERE ItemDescription LIKE '%Bouquet%' AND…
Q: Products_UPDATE should check DiscountPercent. This trigger should error if discount % is 100 or…
A: As technology continues to advance and become more integrated into our lives, it is important to…
Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…
A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…
Q: Determine which orders had a higher total amount due than order 1008.
A: Explanation: The following query determines the orders where the total amount is higher than order…
Q: Create a store procedure that displays the names of salesman located in Paris and their commission
A: So let's understand what are Stored Procedures first. A Stored Procedure is a prepared SQL code…
Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…
A: 9. SELECT rep.rep_ID,rep.last_name,rep.first_name FROM rep WHERE rep.rep_ID IN (SELECT rep_ID FROM…
Q: I need help with a SELECT statement that returns the cust_id and the total number of orders for each…
A: The objective of the question is to write a SQL SELECT statement that returns the customer ID…
Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…
A: According to the information given:- We have to follow the instruction in order to perform the…
Q: For every completed or 'open service request for janitorial work', list the condo id, description,…
A: The querry has given
Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…
A: Queries are given below :
Q: Writing to a CD-R 1. A single track runs in a spiral pattern from the center of the disc to the…
A: Introduction :Given , Magnetic-Tape system ,length of reels = 2400 ftNo. of tracks = 9We have to…
Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…
A: Dear student your query get the error because inv_number exist in the two table so you have to…
Q: Q. Based on the given table, solve the following queries. d) Write a SELECT command to display id,…
A: d) Write a SELECT command to display id, age and name of the employees with their age in both…
Q: For each customer, list the CustomerID and the total number of orders placed in 2015.
A: Answer: Query: select Order_T.Customer ID,sum(OrderLine_T.Ordered Quant from OrderLine_T inner join…
Q: 7. In the OrderItems table, display the maximum item_price with the alias shown. 11.99 Max Item…
A: Algorithm:Select the maximum value of the item_price column from the OrderItems table.Display the…
Q: When used in a parameter query, which of the following WHERE clauses will select the records for…
A: Parameter Query When a Query is used multiple times with different values each time, parameter query…
Q: What are the drawbacks of training a deep neural network with a small amount of labeled data ? The…
A: What drawbacks do deep neural networks have?To perform better than other strategies, it needs a big…
Q: Which customers have not placed any orders for computer desks?
A: JOINS in sql: A JOIN clause in sql is used to combine or join rows from two or more tables, that…
Q: How do I set up the permission for the store manager and cashier also the customers
A: To implement the LusuFlix desktop application with different levels of permissions for users in the…
Q: Task 2: Write and execute the command to retrieve the office number, property ID, and monthly rent…
A: Above query is using the less than operator "<" instead of the greater than or equal operator…
Q: Find out the customers with balance of $3500 or more. Your result should include the most recent…
A: SELECT INVOICE .INV_NUM WHERE TOP INVOICE .INV_DATE DESC, INVOICE .CUST_CODE FROM INVOICE,…
Q: Surpreeth would want to add two additional customer entries to the customer table. Which command is…
A: We are given a situation in a database table where we are going to apply sql command to add new…
Q: Which of the following can be used in queries using multiple criteria in a single field? Group of…
A: The answer for the above question is as follows:
Q: Use select statements to create queries that answer the following questions. Only provide the…
A: Two tables are provided. The name of the first table is Order. The name of the first table is…
Q: What is MINR minimum value across a range of value?
A: MINR: To do complex mathematical calculations, the math instruction “Calculate Expression” is used.…
Q: Task 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for…
A: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each…
which command would you use to determine the amount due from customer?
![The in-charge auditor asks you to determine the total amount due from each
customer.
l Use the appropriate ACL command to determine the total amount due from each
customer. Save the results to a new table (file).
The audit program states that customer balances greater than $35,000 are to be
confirmed 100%. Isolate customers with balances greater than $35,000. How
many customers have balances > $35,000 and what is the total dollar amount
of all accounts with balances over $35,000 to be confirmed?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F32da292f-77e5-4a01-b633-219d5e4f919d%2F5a6214ac-7d44-44a9-b58f-b1622b50ee66%2Fpkjssv_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0. If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20. Test this trigger with an appropriate UPDATE statement.The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0Products_UPDATE should check DiscountPercent. This trigger should error if discount % is 100 or less. This trigger doubles the new discount % from 0–1. A.20% discount. Check this trigger.
- Repeat Task 5 without using the ITEM_INVOICE VIEW to retrieve the item ID, description, price, invoice number, invoice date, quantity, and quoted price for all items with a quoted price that exceed $100.My question is that I don't why that the expected results are the same as my results and I can't get any credit for my assignment. I might be getting something wrong when I inputted my query but I don't know what it is. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. My Query CREATE VIEW MONTHLY_RENTS AS SELECT COUNT(BDRMS) AS BEDROOMS, AVG(SQR_FT) AS AVG_SQUARE_FEET, AVG(MONTHLY_RENT) AS AVG_MONTHLY_RENT FROM PROPERTY ORDER BY BDRMS; Then SHOW FULL TABLES FROM StayWell WHERE table_type = 'VIEW' AND Tables_in_StayWell = 'MONTHLY_RENTS' My results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW Expected Results…The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.
- Write and execute the command to retrieve the customer ID, first name, and last name of each customer in the MAJOR_CUSTOMER VIEW with a balance that exceeds the credit limit.Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the INVOICE_NUM, CUST_ID, FIRST_NAME, LAST_NAME, INVOICE_DATE, and the promotion date for each invoice as PROMOTION_DATE. The promotion date is 20 days after the invoice was placed. Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT. Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID,…In cell B20, enter a formula to calculate the number of clients the sales associate had with annual sales reaching the target set in cell B16. (Hint: This time, use the column label Client as the Field argument. The criteria range should be A15:B16.) Remember, the values in the Client field are text values. Use the appropriate function.
- The team wants to track potential list of users who may have forgotten their items on the cars. Therefore, you need to return USER_FIRST_NAME, USER_LAST_NAME, TRAVEL_START_TIME, TRAVEL_END_TIME information from the USERS and TRAVELS tables connected inside a JOIN statement by the USING function and USER_ID fieldThe InstantRide User Satisfaction team received a phone call from a user who might have left her wallet in the car. She indicated that the license plate of the car was starting with BB-883 but unfortunately, she could not remember the full license plate number. The team wants to get all travel information for the cars with the license plate starting with BB-883. You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number compared with SUBSTR and UPPER functions.Show how to create a view tot credits (year, num credits) that returns the total amount of credits taken in each year.
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)