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 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 view
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.
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
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_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_forwardcreate view that view names of professors and name of projectarrow_forward
- 2. 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_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_forwardCreate 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_forward
- 1)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_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_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_forward
- Create 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_forwardCreate 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_forward15. Open the AttendeeFirstName query in Design View and add criteria to select only those records where the FirstName field value begins with Lau followed by any other letters. Save the changes to the query. Open the query in Datasheet View, confirm that two records appear in the query results, and then close it.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