HomeworkLib
Question

Oracle 12c Based upon the contents of the BOOKS table, which of the following SQL statements...

Oracle 12c

Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?"

SELECT * FROM books;

SELECT title, retail+retail FROM books;

SELECT title, retail^2 FROM books;

none of the above
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1 
SQL statements will display the retail price for two copies of each book currently in inventory is

SELECT title, retail+retail FROM books;
OR
SELECT title, 2*retail FROM books;

Option 2

0 0
Add a comment
Know the answer?
Add Answer to:
Oracle 12c Based upon the contents of the BOOKS table, which of the following SQL statements...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Introduction to Oracle 12c SQL and DB concepts: books ( book_id, title, author_last_name, author_first_name, rating) patrons...

    Introduction to Oracle 12c SQL and DB concepts: books ( book_id, title, author_last_name, author_first_name, rating) patrons (patron_id, last_name, first_name, street_address, city_state_zip, location) transactions (transaction_id, patron_id, book_id, transaction_date, transaction_type) *Book_Id, Patron_id and Transaction_id are primary keys. Patron_id and book_id in transactions table are foreign keys. Possible values for the transaction type are 1 = checking out , 2 = returning 3 = placing a hold. Write SQL to list all patrons and their number of transactions for each transaction type. Include...

  • Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...

    Do these codes look right for the following 5 statements. This is using Oracle SQL: Write a query that displays the title, ISBN, and wholesale cost of books whose wholesale cost is more than the average of all books. Format the retail price with dollars and cents. Write a query that displays the title and publication date of the oldest book in the BOOKS table. Format the date with the complete name of the month and a comma after the...

  • Oracle 12c Chapter 13 Advanced Challenge To perform the following activity, refer to the tables in...

    Oracle 12c Chapter 13 Advanced Challenge To perform the following activity, refer to the tables in the JustLee Books database about to begin an aggressive ma The Marketing Department of JustLee Books i campaign to generate sales to repeat customers. The strategy is to look at existing customers' past purchases,  which these customers have made purchases, JustLee Books will send promotional information about other books in the category that are highly profitable books for the company. The Marketing Department has requested...

  • Oracle 12c SQL - Chapter 5: Case Study: City Jail, Part II Note: You are limited...

    Oracle 12c SQL - Chapter 5: Case Study: City Jail, Part II Note: You are limited to using the Oracle Live interface to create solutions for the problems below. SQL Live does not allow as many commands, statements, and symbols as full Oracle SQL. Specifically, the ampersand substitution variable symbol (&) may not be used for any of the solutions below because Oracle Live does not recognize it. Oracle Live is available to use here: https://livesql.oracle.com/apex/f?p=590:1000 Execute the CityJail_5.sql script...

  • Write the following SQL statements in Microsoft Access by using the Books database from Week 2...

    Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document: Write SQL statements: To update the publisher name from READ WITH US to READ FOR US To verify the updated name field for the publisher with ID 6 To make the following updates to the Publisher table (be careful with WHERE): Make Contact="John Travolta" for publisher with ID number...

  • Oracle 12c: SQL   Joan Casteel ISBN: 978-1-305-25103-8 Chapter 12 Case Study: City Jail Make sure you...

    Oracle 12c: SQL   Joan Casteel ISBN: 978-1-305-25103-8 Chapter 12 Case Study: City Jail Make sure you have run the CityJail_8.sql script from Chapter 8. This script makes all database objects available for completing this case study. The city's Crime Analysis unit has submitted the following data requests. Provide the SQL statements using subqueries to satisfy the requests. Test the statements and show execution results. Use a sql sub-query statement to answer the following: (Please provide correct answer for questions 6...

  • Which of the following queries contains a non-equality join? a. SELECT title, authorid FROM books, bookauthor...

    Which of the following queries contains a non-equality join? a. SELECT title, authorid FROM books, bookauthor WHERE books.isbn = bookauthor.isbn AND retail > 20; b. SELECT title, name FROM books JOIN publisher USING (pubid); c. SELECT title, gift FROM books, promotion WHERE retail >= minretail AND retail <= maxretail; d. none of the above

  • Write a console-based program to simulate the management of a bookstore. The program will provide the...

    Write a console-based program to simulate the management of a bookstore. The program will provide the following functionalities: listing all books; searching for a book; purchasing books. 2. Functionalities The program will maintain a list of books. Each book has the following information: Title; Author; Category; Price; Number of copies The program will provide the following functionalities: 2.1 List all books in bookstore. 2.2 Search for a book • Search for a book based on following criteria: (1) keyword in...

  • This assignment consists of a series of SQL questions. For each question, you will need to...

    This assignment consists of a series of SQL questions. For each question, you will need to include: • SQL query. • An explanation of the query. Please include explanations as a comment AFTER your query, e.g., enclosed within a /* comments block */ ). See the first example in the SQL tutorial for a comment. You don’t need to explain straightforward code in comments. Only the parts that are interesting or different, so that we understand what you did. Question-1...

  • Advance Challenge To perform this activity, refer to the tables in the JustLee Books database. Management...

    Advance Challenge To perform this activity, refer to the tables in the JustLee Books database. Management is proposing to increase the price of each book. The amount of the increase will be based on each book’s category, according to the following scale: Computer books, 10%; Fitness books, 15%; Self-Help books, 25%; all other categories, 3%. Create a list that displays each book’s title, category, current retail price, and revised retail price. The prices should be displayed with two decimal places....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT