WEB 250 Project 2 - SQL

1) For this part you are going to modify the contents in the tables. (Don't forget to include your SQL in a file that you submit to me. Remember it needs to be an sql file, so it will have a .sql extension on the end of it.)

1. The 1NR in the Units table is for a one night stay. The cost was to low for The View cabin, so please change it to 300 for one night.
2. In the Units table all the baths should be in a numeric format. Rather than having a two, the format should be 2. This way in the future if we display this data in a drop down menu two and 2 are not both displayed.
3. River Rapids has bought The Better Rafting Company. We need to update the company name.
4. We Hike has decided to add Jeep Tours to what they offer. We need it added. You can make up your prices and other information. You will probably notice that data should be added to multiple tables.
5. River Rapids just created a website. They need to add the website to each of their packages. Go ahead and add it. (You can make up the website)

2) This last section will focus on creating statements that will pull data from the different tables (Don't forget to include your SQL in a file that you submit to me. Remember it needs to be an sql file, so it will have a .sql extension on the end of it.)

1. We need to know the cabins that have two bathrooms.
2. We also need to know the cabins that cost less than $220.
3. Now we need to see all the cabins that have three or more bedrooms in Bryson City.
4. Next we need to see all the rafting and kayaking trips offered by River Rapids in descending order.
5. The last thing we need to see are the compay names that offer the services in ascending order. Please do not duplicate names.