1004 BB-189-MM MERCEDES E200 2019 TRAVEL ID TRAVEL START TIME TRAVEL END TIME TRAVEL START LOCATION TRAVEL END LOCATION TRAVEL PRICE DRIVER ID CAR ID USER ID TRAVEL DISCOUNT 5001 2019-10-01 04:04:55 2019-10-01 04:14:19 9614 York Road 84 Church Lane 15.44 2001 1003 3005 NULL 5002 2019-10-01 05:57:33 2019-10-01 06:12:33 47 Church Street 68 High Street 20.56 2001 1003 3006 NULL 5003 2019-10-01 13:35:20 2019-10-01 13:45:10 2 Windsor Road 95 West Street 12.32 2002 1001 3002 NULL 5004 2019-10-02 08:44:48 2019-10-02 09:15:28 9060 Mill Lane 27 Main Road 30,49 2003 1002 3001 0.13 5005 2019-10-02 16:38:54 2019-10-02 16:48:10 2 Queensway 24 Mill Lane 11.15 2001 1003 3007 NULL 5006 2019.10-03 19:12:14 2019-10-03 19:23:45 50 Main Road 93 Broadway 14.61 2003 3007 0.10 1002 5007 2019-10-03 16:06:36 2019-10-03 16:08:56 39 Park Road 91 West Street 4,41 2002 1004 3003 0.14 5008 2019-10-03 17:17:12 2019-10-03 17:37:42 37 The Drive 17 Stanley Road 25.12 2001 1003 3001 0.25 5009 2019-10-03 21:16:48 2019-10-03 21:26:18 77 MilI Road 724 Springfield Road 13.55 2001 1003 3005 NULL 5010 2019-10-03 23:21:40 2019-10-03 23:39:10 16 Church Road 30 North Road 25.62 2003 1002 3003 0.20 DRIVER ID DRIVER_FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING 2001 Willie Butler 1874501 2019-09-12 4.4 2002 Justin Howard 1953853 2019-09-09 1 4.8 2003 Anthony Walker 1735487 2019-09-15 3.5 2004 Ece Yilmaz 1734747 2019-08-15 1 USER ID USER FIRST_NAME USER LAST_NAME USER EMAIL 3001 Jack Hill j.hill@xmail.com 3002 Ryan Collins r.collins@xmail.com 3003 Nursin Yilmaz n.atak@gmail.com 3004 Sarah Price s.price@xmail.com 3005 Bobby Griffin b.griffin@xmail.com 3006 Randy Clark r.clark@xmail.com 3007 Jose Thomas j.thomas@xmail.com 3008 Nursin Yilmaz n.yilmaz@xmail.com

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Name of the procedure - ADD_INVOICE Name of relation - INVOICES Suppose datatype of INVOICE_NUM,…

Q: CREATE PROCEDURE  'DISPLAY_OWNER' (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT…

A: Task-4 To Create a Procedure use Syntax- CREATE PROCEDURE procedure_name(parameter1 IN/OUT/INOUT…

Q: Could you help me figure out the query for this task? The Car Maintenance team wants to pre-order…

A: Given :                   CARS(CAR_ID, CAR_PLATE, CAR_MODEL, CAR_YEAR)

Q: In cell F4, create a formula using the HLOOKUP function to determine the Cost per participant for…

A: Question 1. In cell F4, create a formula using the HLOOKUP function to determine the Cost per…

Q: how would I do this Return a list of all properties where service requests are made with different…

A: We must return the Service-request table, which contains requests for the same property with…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: You’re creating a new table consisting of three columns: Col1, Col2, and Col3. Col1 should be the…

A: It requires only two constraints, one PRIMARY KEY constraint for Col1 and one NOT NULL constraint…

Q: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Below is the query to get the desired output:

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: Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of…

A: Based on the given information, the following SQL code can be used to create the requested view: --…

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: 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: ITEM_ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE AD72 Dog Feeding Station 12 DOG B 79.99 BC33…

A: Run the following sql command for the problem

Q: I am working on the stored procedure. However, I am stuck a little and cannot figure out how to get…

A: Below is the answer with explanation:

Q: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: Check the query below.

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Modify what you consider to be the best design to include a column called AwardPurchaseAmount. The…

A: To add an Award Purchase Amount column, data required includes the customer's unique ID, here Email…

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: Task 18: List the item ID, description, unit price, and category for each item that has a unit price…

A: Task 18: ALL Operator: The operator is used with WHERE or HAVING clause. If ALL operator is used in…

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: The InstantRide User Satisfaction team are looking forward to creating discounts for the users.…

A: This can be done with the help of a SQL query that can simply check for repeated user registrations…

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: The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers…

A: This is a alter command in mysql to add check in already created table.