Create a stored procedure named spPriceRange that accepts two optional parameters. The procedure should return a result set consisting of Product Id, Product Name, Product Description, and List Price from the product and product description tables for each product within the price range, sorted with largest price first. The parameter @PriceMin and @PriceMax are parameters used to specify the requested range of prices. If the minimum price is not provided use the minimum non-zero price in the product table. If the maximum price is not provided use the maximum price in the product table."

Q2:Write a row-level trigger that executes before updating a project’s location in the project table. The trigger changes the department number of the project to 4 if the location is in ‘Stafford’. SQL

The data section called Transaction Growth shows how many clothing sets were sold each month. Felicia entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. She notices that all of the values in the range are 2,146, even though more clothing sets than this were sold in some months. Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.

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.

Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:

You have the following table: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) Write a Stored Procedure that returns the last name and first name for all managers in a department with the DEPARTMENT passed in as a parameter. Answer: To write a stored procedure

Create a procedure to allow company employee to add new product to the database. This procedure needs only IN parameters.

Help understanding / installing phpmyadmin and if i need wamp server aswell and where to copy and paste this code in order to create a database

use the RUST

StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.

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!)

The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE. Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.

I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test your trigger COMPLETELY for every event it is defined. (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging). This should work both for new rows and existing rows that are updated. Scenerio: All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.