Question: Repeat exercise 11, but this time list only hiking tips in the state of New Hampshire (NH), list each trip only once, and sort the

Repeat exercise 11, but this time list only hiking tips in the state of New Hampshire (NH), list each trip only once, and sort the results in descending order by trip name.

Question 11. Find the trip name of all reservations for hiking trips and sort the results by trip name in ascending order.

SQL Code for Q11:

SELECT DISTINCT TRIP_NAME FROM RESERVATION, TRIP WHERE RESERVATION.TRIP_ID = TRIP.TRIP_ID AND TYPE ='Hiking' Order by TRIP_NAME;

Having trouble getting the SQL code right for Q18

using textbook A Guide to SQL 9th edition and oracle application express to run the SQL code

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

need help In the following exercise, you will use the Access Files located in the Files section of your Canvas shell. For this assignment I do not want a MS Access file but rather a snapshot of the...

need help For this assignment I do not want a MS Access file but rather a snapshot of the QBE. Also, show the result of the query after it is executed. -Complete a QBE design grid using MS Access for...

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

solve this ms access queeries and show the steps how to do each question Colonial Adventure Tours Case The owner of Colonial Adventure Tours knows that being able to run queries is one of the most...

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

In each of the following queries, use SQL to obtain the desired results using the data shown in the Colonial Adventure Tour Database listing found on the homepage under the databases heading. Also,...

For this extra credit assignment, you will complete the major forms that you learned about in the rst three weeks of class-~Forms 941, W-3, W-2. 940 and an Annual Reconciliation worksheet-- for a...

Divide into two teams. One team must prepare a presentation advocating for the separation of the roles of chairperson and CEO. The other team must prepare a presentation arguing for the continued...

Two triangular plates, each of mass 8 kg, are welded to a vertical shaft AB. Knowing that the system rotates at the constant rate = 6 rad/s, determine its angular momentum about G. C - - 750 mm- B ...

If the auditor s estimate of the amount of misstatement that might be present in an audit population is less than the tolerable misstatement for the account, then which of the following is not true?...

A6: You are going on a road trip with friends in a car that can travel 47 kilometers per gallon. (a) How many gallons of gas will it take you to travel 1230 miles from GR to Orlando? (b) If gas costs...

6. Notify employees of the change. Announce the change to an online handbook in a way that ensures all employees will know about the new format. Consider a mandatory sign-on within the transition...

3. Research the various ADR options to determine which ones are the best fit for the organization. For example, peer review is most successful when there is a high level of trust within the workforce.

7. Immediately notify employees of changes. Be sure to develop a process for maintaining the handbook and letting employees know when things change. While an online handbook can be easily updated, it...