Determine the amount of total profit generated by the book purchased on order 1002. Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places. Take into account that the customer might not pay the full retail price, and each item ordered can involve multiple copies. SELECT title, TO CHAR(quantity-(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# = 1002; SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# = 1002; SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# IN ( 1002,1003,1004)

Determine the amount of total profit generated by the book purchased on order 1002. Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places. Take into account that the customer might not pay the full retail price, and each item ordered can involve multiple copies. SELECT title, TO CHAR(quantity-(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# = 1002; SELECT title, TO_CHAR(quantity(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) SELECT title, TO_CHAR(quantity(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# = 1002; SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99') FROM books JOIN orderitems USING (isbn) WHERE order# IN ( 1002,1003,1004)

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

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%'
Use select statements to create queries that answer the following questions. Only provide the information requested. Do not provide the output. All tables are provided below List the name of all bouquets that are priced at $29.99. List the customer id for all customers who ordered item 7.
DONT COPY FROM CHEGG == REPORT + DISLIKE 9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Please answer accordingly..
Shop (ShopCode, ShopName, ShopSales) Which of the following queries displays name of the shop that has the highest average shop sales. Select one: a.SELECT shopName FROM shop GROUP BY shopName HAVING max(avg(shopSales)) b.SELECT shopName FROM shop WHERE avg(shopSales) GROUP BY shopName; c.SELECT shopName FROM shop WHERE avg(shopSales) = (SELECT max(avg(shopSales)) FROM shop GROUP BY shopName); d.SELECT shopName FROM shop GROUP BY shopName HAVING avg(shopSales) = (SELECT max(avg(shopSales)) FROM shop GROUP BY shopName);
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';
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.
The date used in the answer is not the date used in the question. INCORRECT.
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.
A variable to store the average score of the student’s prelim exam grade.