Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts
I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts I haven't quite mastered
I will attach screenshots of the tables needed. Please help me with these queries b-j.
v structure of PADDLING table
In response to the comment: Question f is inserting this column. It is one of the things help is needed with.. According to my instructions, the minimum group size is only relevant to the PADDLING table.
b. Run a query for all paddling trips located in New Hampshire that increases the max group size by 2 unless it is already over 12. Insert a new trip into the database with a trip ID of 43, named Paddling Lake Granbury, in TX, with a max group size of 15, a distance of 6 and the season is Summer. Delete all paddling trips that are in CT. The max group size for the Lower Pond Tour in ME is under review due to changes in permits from the park department. Your boss wants you to update the table to show that this number is unknown at this time. Add a new column to the paddling table that indicates a minimum group's size and set the default value for all trips to 4 c. d. e. f. g. Change the table to disallow null values in the new field for group minimum size h. Change the minimum group size for all paddling trips in CT to 5 i. Decrease the customer's first name field to a length of 25 j. Delete the paddling table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started