Write and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100. I have been trying this solution and it is incorrect: SELECT i.item_id, i.description, l.invoice_num, l.quoted_price FROM item i INNER JOIN invoice_line l ON i.item_id = l.item_id WHERE i.item_id IN ( SELECT item_id FROM item_invoice WHERE quoted_price > 100 );

Write and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100. I have been trying this solution and it is incorrect: SELECT i.item_id, i.description, l.invoice_num, l.quoted_price FROM item i INNER JOIN invoice_line l ON i.item_id = l.item_id WHERE i.item_id IN ( SELECT item_id FROM item_invoice WHERE quoted_price > 100 );

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 2SCG: Create a view named CONDO_OWNERS. It consists of the location number, unit number, square footage,...

See similar textbooks

Similar questions

Create a view named CONDO_OWNERS. It consists of the location number, unit number, square footage, bedrooms, baths, condo fee, and owners last name for every condo inwhich the number of bedrooms is three. a. Write and execute the CREATE VIEW command to create the CONDO_OWNERSview. b. Write and execute the command to retrieve the location number, unit number,condo fee, square footage, and owners last name for every condo in theCONDO_OWNERS view with a condo fee of less than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
List the reservation ID and trip ID for all trips that occur in the month of July, 2016. There are multiple ways to create this query. Write an alternate command that would produce the same result.
What is the format of the SET clause that changes the value in a column to null in an UPDATE command?
Which of the following types of restrictions can be viewed with the DESCRIBE command? NOT NULL FOREIGN KEY UNIQUE CHECK
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
Task 5: Write and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100.
Create a view named RESERVATION_CUSTOMER. It consists of the reservation ID, tripID, trip date, customer number, customer last name, customer first name, and phonenumber. Write and execute the command to retrieve the reservation ID, trip ID, trip date, andcustomer last name for every reservation in the RESERVATION_CUSTOMER viewwith a trip date of September 11 , 2016. WHAT AM I MISSING OR HAVE INCORRECT ? SELECT Reservation_ID, Trip_ID, Trip_Date, Last_Name FROM RESERVATION_CUSTOMER WHERE TRIP_DATE = '09-SEP-2016';
Task 2: Write and execute the command to retrieve the office number, property ID, and monthly rent for every property in the SMALL_PROPERTY view with a monthly rent of $1150 or more. This is my response. However it isn't working when I check the file. Also the table isn't popping up like the other completed queries, can you let me know where I went wrong and provide correct reponse. Thanks, CREATE VIEW TASK2 AS SELECT OFFICE_NUM, PROPERTY_ID, MONTHLY_RENTFROM SMALL_PROPERTYWHERE MONTHLY_RENT < 1150;
Write and execute the command to retrieve the reservation ID, trip ID, trip date, and customer last name for every reservation in the RESERVATION_CUSTOMER view with a trip date of September 11, 2016.
write and execute the command to retrieve the reservation id, trip id, trip date, and customer last name for every reservation in the reservation _ customer view with a trip date of September 11,2016.
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.
8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;