Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
create view that view names of professors and name of project
1. Create a view that lists the name and phone number of the contact person at eachpublisher. Don’t include the publisher’s ID in the view. Name the view CONTACT.
SQL commands
Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book need to be reordered. Name the view REORDERINFO.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO.arrow_forwardCreate a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.arrow_forwardA new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009arrow_forward
- Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in New Hampshire (NH). Display the data in the viewarrow_forward1) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. 2) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not assume that the loan table is non-empty or that there is one row of result as in general, there may be more than one customers with the most number of loans.arrow_forward2. Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName, LastInvoice (the most recent invoice date), and SumOfInvoices (the sum of the InvoiceTotal column). Return only the 10 vendors with the largest SumOfInvoices and include only paid invoices.arrow_forward
- Create a view named "allOrders" containing all the retail order information of whose statusis 'on hold' and who have ordered during April 2005. Display the results of the view created.arrow_forwardMS SQL Server create a view that contains clients and their total balances in their accounts. The view attributes should be client social security number, client first name, client last name, client date of birth, and the total balance. Specify the view creation statement below:arrow_forward1)To list the number of equipment with the same first three letters (the start code, e.g., CAM, DIV) in the equipment code for equipment loaned or returned in the month of June. You should list the start code and the number of equipment types ONLY if there is more than 2 such equipment with the start code.2) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear.3) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not assume that the loan table is non-empty or that there is one row of result as ingeneral, there may be more than one customers with the most number of loans.arrow_forward
- Create a view named TopLevelCust view. It consists of the number, name, address, balance, and credit limit ofall clients with credit limits that are greater than or equal to $10,000. Display the data in the view.arrow_forwardTask 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. Task 12: List all the views contained within the system catalog, but only display the first 12 records.arrow_forwardCreate a view containing the records for each guest at the ParkView Hotel Hotel (hotelno, hotelname, city) Room (roomno, hotelno, Type, price) Booking (hotelno, guestno, datefrom, dateto, roomno) Guest (guestno, guestname, guestaddress)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage