List the name distance and start location for each trip that has the type Hiking and that has the distance greater than 8 miles.
List the name, distance and start location for each trip that has the type Hiking and that has the distance greater than 8 miles.
- List and describe briefly 4 Built-in functions (aggregate functions) in SQL with examples.
Note: You are required to show how to use these functions inside a SQL query by using an example.
(10 Marks)
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now
- You are required to download the database file called “Colonial Adventure Tours” (which is available in Moodle Learning management system), on to your hard drive.
Write SQL queries (do not use QBE) for the following questions and execute the queries using the above database on MS Access. Include screen shots of the outputs and all SQL statements you used to answer following questions (2(a) – 2(e)).
(3 marks for each screen shot & 5 marks for each query= 8 x 5 =40 Marks )
- List the name, distance and start location for each trip that has the type Hiking and that has the distance greater than 8 miles.
- List the name of each trip and distance that has the type Paddling or that is located in Poland.
- Find how many reservations include a trip with a Total price (TripPrice+otherfees ) that is greater than $20 but less than $75.
- Count the number of trips originate in each state.
- Create a new table maned “Hiking” that includes TripID, NumPersons from Reservation table and Trip Type, Trip Name columns from Trip table where Trip type is “Hiking” .
- Describe types of anomalies that may occur on the following table that has redundant data.
(10 Marks)
- Propose a suitable solution to overcome anomalies identified in 3(a).
