In need of Database Scripting assistance. My current assignment has me baffled and I need to turn it in soon. I have read my textbook required chapters and watched many multi-media videos and presentations related to the topic. I have copied/pasted the assignment.
The tables are not important I just need to know the proper syntax to complete the following bullets. I can plug the information as needed. Thank You
- Display all bowlers first and last names in one column result set, renaming the columnBowler's Name.
- Display a list of all bowlers and addresses formatted suitability for a mailing list, sorted by zipcode.
- What was the point spread between a bowler's handicap and raw score for each game played in match 10? Rename the point spread field in the data result set asPoint Differenceand sort on the match field.
- Display the 3rd, 4th, and 5th letters of each tournament location displaying the resulting data set asLocation Letters.
- Using a string function, display the tournament location of the tournament that occurred on 12/04/2012 in uppercase letters.
- Show the last name of each bowler that lives in Seattle, WA in lowercase letters. Rename the column in the datasetbowler.
- Display each bowler's last name, first, name and middle initial all in lowercase in one result column. Be sure that you include spaces between each piece of data. Also, rename the field asFull Name.
- For the bowler named David Cunningham, display only the world Old that is located in his address. Rename the field in your resultPartial Address.
- Display the team name MintJuleps asMint Juleps, naming the new resulting columnNewName.