Write SQL codes for each of the questions listed below. Use the ERD on the second page
Question:
Write SQL codes for each of the questions listed below.
Use the ERD on the second page to identify the table names andattribute names (make any relevant assumptions about the datatypes).
Total Value = 10 points
Submit this assignment as a Word document.
Questions:
Show the names and duration of all tours that have the word“Ski” anywhere in the name. (1 point)
For each tour show the tour name and the cost, for all tripsthat cost between $500 and $1000. (1 point)
For each travel group, show the names of all customers in thegroup, where the group_name has “Penn State” in it. (1 point)
What is the cost of the most expensive tour? (1 point)
Prompt the user to enter the tour city (for example“Philadelphia”) and show the names and costs of all the tourslisted for that city. (2 point)
Write the code to add two new rows of data to the Sales table.(1 point)
Show the names and startdate of all tours that were sold onApril 1, 2014. (1 point)
Show the first name, last name and phone number of everycustomer that booked a tour to the city of Harrisburg. (2point)
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi