Create a function that will calculate the total amount after tax (note: total amount after tax = amount + (amount * .15 ) (hint: use the following query before building the function: SET GLOBAL log_bin_trust_function_creators = 1 )

Create a function that will calculate the total amount after tax (note: total amount after tax = amount + (amount * .15 ) (hint: use the following query before building the function: SET GLOBAL log_bin_trust_function_creators = 1 )

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter9: Working With Text Functions And Creating Custom Formats

Section: Chapter Questions

Problem 2.8CP

See similar textbooks

Similar questions

Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
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.
P5
Question 5 Suppose that you have the following table: CREATE TABLE coupons ( coupon id INTEGER name VARCHAR2 (30) duration INTERVAL YEAR (3) TO MONTH Now, considers the following INSERT statement: INSERT INTO coupons (coupon id, name, duration) VALUES (4, 'BD1.5 Corn Flakes, INTERVAL 1- 3 YEAR TO MONTH) The above INSERT statement stores the following data: A. 4 BD1.5 Corn Flakes +000-14 4 BD1.5 Corn Flakes +014-00 4 BD1.5 Corn Flakes +014 None of the above
WEEK SQL ASSIGNMENT Complete the following exercise: Alter your student table adding a new column called enroll_date using the datetime data type. Populate the new column (enroll_date) with the current date and time. Using your student table return the student first and last names concatenated with a space and then the enroll_date minus one month. Here is an example of the output: Name Date Jane Smith 2019-05-03 13:14:12 Tom Jones 2020-08-07 05:23:56 Using your student table return the month name for the enroll_date column. For example, if the enroll_date was 11-6-2019 then the month name would be June.
Which of the following statements is/are False? O Label encoding increases the overall number of dimensions O R square increases with number of independent variables O One hot encoding increases the overall number of dimensions O All of the above Which of the following is true about clustering? O Scaling the data is not necessary for clustering O K-means clustering results vary based on initialization points O Outlier treatment is not required for clustering O Categorical variables can be used in clustering without any preprocessing
Please written by computer source
9 .
473/quizzes/3522244/take Question 3 15 pts Prompt: Develop a query to provide details about customer sales at the end of 2014. You want the output to include the following attributes in this order: sale ship-to city, customer last name, and sale ship date. Restrict the query to include sales that were shipped to cities that end in the letter "o" and were shipped on a date within the last four months of 2014. Sort the query output first by the ship- to city and next by the customer last name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Sale.ShipToCity, Customer.LastName, Sale.ShipDate FROM Sale JOIN Customer ON Sale. SalelD =Customer. CustID WHERE Sale.ShipToCity LIKE "%o" AND Sale.ShipDate BETWEEN "2014-09-01" AND "2014-12-31" ORDER BY Sale.ShipToCity, Customer.LastName; Query Result Count (enter number only, ex. 12): Result: rows
Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION: Use the region table to create a function called ‘Return_region_name’ which accepts an input parameter ‘region_id’, and print the name of the region with that id. Then execute this function with region_id = 1. [LAB-7] (3) B) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_id as an input parameter to show its corresponding node id to the banker. Then execute this procedure with cust_id=5. [LAB-7] (2) C) Trigger: Create a row-level trigger called ‘Compute_Amount_trigger’ on the cust_txn table to automatically update the amount of withdraw transaction made after inserting or updating amount on the cust_txn table. Additionally, this trigger must show this statement ‘TRIGGER MESSAGE: The amount of cust_id and txn_type is modified successfully'. Then test your trigger by updating the cust_txn table. For example, update the amount of the…
How does a parameter query differ from a select query?
i want the codes of create table and insert table only please