CREATE PROCEDURE 'DISPLAY_OWNER' (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10)) BEGIN SELECT OWNER_NUM,FIRST_NAME,LASTNAME INTO I_OWNER_NUM,I_FIRST_NAME,I_LAST_NAME FROM Table-Name WHERE OWNER_NUM = I_OWNER_NUM; END%%

CREATE PROCEDURE 'DISPLAY_OWNER' (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10)) BEGIN SELECT OWNER_NUM,FIRST_NAME,LASTNAME INTO I_OWNER_NUM,I_FIRST_NAME,I_LAST_NAME FROM Table-Name WHERE OWNER_NUM = I_OWNER_NUM; END%%

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Related questions

Q: Consider the following set of tasks and their associated profits and deadlines, in a dual-core…

A: Introduction:Given a dual core processor system's task and their profit with deadlines are given we…

Q: Task3: Write SQL Queries • At least 2 queries involving GROUP BY, HAVING, and aggregate operators. •…

A: Please check the solution below

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to…

A: Given: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides…

Q: The platform is the largest MOOC platform. O a. Coursera b. O b. Udacity O c. Massive Open Online…

A: Explanation:- Соurserа wаs fоunded in 2012 by twо Stаnfоrd рrоfessоrs. With mоre thаn 37…

Q: Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for…

A: Answer: Tables: Invoice: Date Invoice Number Invoice Amount Invoice Tax Invoice Total…

Q: The StayWell marketing team wants to send mail to all residents. You need to return the first name…

A: Explanation:

Q: Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: An SQL prepared code that may be saved and reused repeatedly is known as a stored procedure. So, if…

Q: Task 3: List the customer ID, first and last names, and balance for all customers. The balance…

A: round()- used to round the values to the nearest integer

Q: Create a procedure that takes instructor_ID as a parameter. Name it INSTR_SECTIONS. The…

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

Q: need the awnsers to the following. Lab 8-2: StayWell Student Accommodation Task 5: Create the…

A: According to our expert answering guidelines, we can answer up to 3 subparts questions at a time,…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: need the awnsers to the following. Lab 8-2: StayWell Student Accommodation Task 5: Create the…

A: According to our expert answering guidelines, we can answer up to 3 subparts questions at a time,…

Q: Task 21: List the item ID, description, and category of all items that are in the DOG or CAT…

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

Q: similary i applied for employee table but am getting error if i use like this: select employee…

A: SQL (Structured Query Language) is a programming language for managing and manipulating relational…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: þverdue tasks are highlighted in Select an answer: green yellow orange red

A: The answer of this question is as follows:

Q: Task 1: The StayWell Property Management team wants a list of all property addresses combined with…

A: Task 1: The StayWell Property Management team wants a list of all property addresses combined with…

Q: The InstantRide received some traffic violation tickets from the government. The Legal team of…

A: LEFT JOIN is a type of join which returns all the contents(rows) from the left table and the…

Q: Lab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer…

A: GET_INVOICE_DATE procedure: CREATE PROCEDURE GET_INVOICE_DATE @INVOICE_NUM nvarchar(10) AS SELECT…

Q: ask 3: The Car Maintenance team wants to insert and store the following maintenance types to the…

A: The CREATE TABLE statement is used to create a new table in a database. Syntax: CREATE TABLE…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly…

A: 1: Select the columns OFFICE_NUM, ADDRESS, OWNER_NUM. LAST_NAME, MONTHLY_RENT in the PROPERTY table…

Q: Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is…

A: Here, we are using dateadd function to add 20 days into the invoice date the day today function…

Q: Task 1: The StayWell Property Management team wants a list of all property addresses combined with…

A: Task 1 Explanation: To answer this question, we are going to use PROPERTY and OWNER tables as we…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: SQL: SQL (Structured Query Language) is a domain-specific programming language designed to…

Q: StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests…

A: Given: StayWell’s maintenance team wants to recheck the apartments that had plumbing service…

Q: in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first…

A: I have to create two separate one for the interactive Start Button and next Step for the columns.…

Q: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: Procedure DELIMITER// CREATE PROCEDURE VATCalculator() BEGIN SELECT…

Q: Based on the UML class diagram below, name all the classes that an object of the Rectangle class can…

A: In Java, one of the most significant ideas is typecasting, which is the process of converting one…

Q: Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List…

A: Select Item_Id , description ,Price , Price*(1-0.10) AS [Discount Price ] from Item ;

Q: The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the…

A: DAY(date) : returns the day of the month (from 1 to 31) for a specified date. MONTH(date) : returns…

Q: Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city…

A: A standardized programming language that manages the relational database is called SQL or structured…

Q: List the owner number, the owner's first name as FIRST and the owner's last name as LAST for all…

A: Statement:

Question

I've done Tasks 1-3.

I need help with Task 4.

Tasks 1-3

Task 1

SELECT OWNER_NUM,UPPER(FIRST_NAME) AS "FIRST",LOWER(LAST_NAME) AS "LAST" FROM OWNER;

Task 2

SELECT OWNER_NUM,LAST_NAME FROM

OWNER WHERE UPPER(CITY)="SEATTLE";

Task 3

SELECT PROPERTY.OFFICE_NUM, PROPERTY.ADDRESS, OWNER.OWNER_NUM, OWNER.LAST_NAME,

PROPERTY.MONTHLY_RENT, ROUND((1.75*PROPERTY.MONTHLY_RENT)/100) AS DISCOUNT

FROM PROPERTY, OWNER

WHERE PROPERTY.OWNER_NUM = OWNER.OWNER_NUM

Supposed Query for Task 4

CREATE PROCEDURE 'DISPLAY_OWNER' (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10))

BEGIN

SELECT OWNER_NUM,FIRST_NAME,LASTNAME INTO I_OWNER_NUM,I_FIRST_NAME,I_LAST_NAME

FROM Table-Name

WHERE OWNER_NUM = I_OWNER_NUM;

END%%

DELIMITER;

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Task 1: The InstantRide received some traffic violation tickets from the government. The Legal team of InstantRide requires the travel information of the respective drivers along with corresponding Driving License IDs to proceed further. In addition, the team wants to include the drivers without travel information in the system yet for the completion of driver list. Therefore, you need to return DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID, TRAVEL_START_TIME, TRAVEL_END_TIME information from the DRIVERS and TRAVELS data connected by LEFT JOIN. Task: Query all drivers with and without travel data. (SQL Database Test)
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are: date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample data).
Task 1: List the owner number, the owner's first name as FIRST and the owner's last name as LAST for all owners. The first name should appear in uppercase letters and the last name should appear in lowercase letters.
Task 21: List the item ID, description, and category of all items that are in the DOG or CAT category and contain the word Small in the description. Expected ResultsITEM_ID DESCRIPTION CATEGORYLD14 Locking Small Dog Door DOGSP91 Small Pet Carrier CAT This is the solution I have been trying that is not working: SELECT ITEM_ID, DESCRIPTION, CATEGORY FROM ITEM WHERE CATEGORY AND('CAT', 'DOG') AND DESCRIPTION LIKE '%SMALL%';
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
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 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.
Lab 8-1: KimTay Pet Supplies 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, I_CUST_NAME, and I_INVOICE_DATE. IN SQL CODE. CUSTOMER CUST_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal3@example.com 17.25 250.00 15 375 Melanie Jackson 42…
need the awnsers to the following.Lab 8-2: StayWell Student Accommodation Task 5: Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam', 'Afyouni', '100 Hello St', 'Anytown', 'MA', '55555'); Task 7: Create the UPD_OWNER_LAST_NAMEprocedure to change the last name of the owner whose number is stored in I_OWNER_NUM (provided as a parameter) to the value currently found in I_LAST_NAME. Task 8: Create the DEL_OWNER procedure to delete the owner whose number is stored in I_OWNER_NUM (provided as a…
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.