7. Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price). REPITEMEDIT REP_NUM LAST_NAME FIRST_NAMESTREETSTATE POSTAL CODE COMMISSION RATEEDIT ITEM_NUMDESCRIPTIONON HAND CATEGORY STOREHOUSE PRICECITY15СаmposRafael724 Vinca Dr.GroveCA9009223457.506AH74Patience9GME322.9930GradeyMegan632 Liatris St.FulltonCA900854131708BR23Skittles21GME229.9945TianHui1785 Tyler Ave.Northfield CA9009827789.2506CD33Wood Block Set (48 piece) 36TOY189.4960SeftonJanet267 Oakley St.Congaree CA9009706DL51Classic Railway Set12ΤΟΥ3107.95row(s) 1-4 of 4DR67Giant Star Brain Teaser24PZL231.95DW23Mancala40GME350CUSTOMERFD11Rocking Horse8TOY3124.95FH24Puzzle Gift Set65PZL138.95EDIT CUSTOMER_NUMCUSTOMER NAMESTREETCITYSTATE POSTAL_CODE BALANCE CREDIT LIMIT REP NUM28 Laketon St.Fulton1210.25КА12Cribbage Set56GME375126Toys GaloreСА90085750015260Brookings Direct452 Columbus DrGroveKD34Pentominoes Brain Teaser60PZL214.95CA900925751000030334The Everything Shop342 Magee StCongareeCA900972345.75750045KL78Pick Up Sticks110GME10.95386Johnson's Department Store124 Main St.NorthfieldCA90098879.25750030MT03Zauberkasten Brain Teaser45PZL45.79440Grove Historical Museum Store 3456 Central Ave.FulltonCA90085345500045NL89Wood Block Set (62 piece)32ΤΟΥ3119.75502Cards and More167 Hale St.MesaCA901045025.75500015TR40Tic Tac Toe75GME13.99586Almondton General Store3345 Devon Ave.Almondton CA901253456.751500045TW35Fire Engine30ΤΟΥ2118.95665Cricket Gift Shop372 Oxford St.GroveCA90092678 9750030row(s) 1- 15 of 15713Cress Store12 Rising Sun Ave. CongareeCA900974234.61000015796Unique Gifts786 Passmore StNorthfieldCA90098124.75750045824Kline's945 Giham St.MesaCA901042475.991500030893All Season Gifts382 Wildwood AveFulltonCA90085935.75750015row(s) 1- 12 of 12ORDERSOPRDER LINEEDIT ORDER NUM ORDER DATE CUSTOMER_NUMEDIT ORDER_NUM ITEM_NUM NUM_ORDERED QUOTED_PRICE51608CD3386,995160810/12/201512651610KL782510.955161010/12/201533451610TR401013.9951613DL51104.955161310/13/201538651614FD111124.955161410/13/201526051617NL894.115.995161710/15/201558651617TW353116.9551619FD112121.955161910/15/201512651623DR6729.955162310/15/201558651623FH241236.955162510/16/201579651623KD341013.151625MT038.45.79row(s) 1 -8 of 8row(s) 1- 12 of 12

I have Provided this answer with full description in step-2.

Answered: Show all item num from the item table,…

Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
In cell D5, create a formula using the VLOOKUP function to determine the cost per participant for the Game Room workshop based on the Workshop ID in cell A5. Use range H4:I11 as the lookup table and the cost per participant listed in column 2 of the lookup table. Do not enter a calue for the optionional range_lookup argument.
Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1 Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ; Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64
Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians. CREATE TABLE Movie ( ID INT AUTO_INCREMENT, Title VARCHAR(100), Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), ReleaseDate DATE, PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES ('Casablanca', 'PG', '1943-01-23'), ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'), ('The Dark Knight', 'PG-13', '2008-07-18'), ('Hidden Figures', 'PG', '2017-01-06'), ('Toy Story', 'G', '1995-11-22'), ('Rocky', 'PG', '1976-11-21'), ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';
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.
What is the main difference between the set operators and the join?
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Write a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER table, call this CUSTOMER_NAME), Phone number of ALL Customers (based on CUS_AREACODE and CUS_PHONE in CUSTOMER table, call this CUSTOMER_PHONE), for those haven’t flied before (based on the record in CHARTER table).
The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.