Need of database scripting assistance

Assignment Help Basic Computer Science

Reference no: EM13721713

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.

Reference no: EM13721713

Questions Cloud

Create a technology stock index : Suppose you need to create a technology stock index. You are not sure if you should do a market cap weighted index or a price weighted index. You will use 2 stocks to make this index:

Design a class named clock that contains private data fields : Design a class named Clock that contains private data fields for startTime and endTime, no argument constructor that initializes the startTime to the current time, a method named start() that resets the startTime to the given time, a stop() me..

Identify the federal income tax issues that pete faces : Orange Inc, a calendar year corporation in Clemson, South Carolina, elects S corporation status for 2014. The company generated a $74,000 NOL in 2013 and another NOL of $43,000 in 2014. Orange recorded no other transactions for the year.

Calculate the return the stock had at time of margin call : An investor buys $8,000 worth of a stock priced at $40 per share using 50% initial margin. The broker charges 6% on the margin loan and requires a 30% maintenance margin. In one year the investor gets a margin call.

Need of database scripting assistance : 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/pa..

Assume the market interest rate : The operating cost of a new machine is $500 for the first year. Starting the second year, the operating cost increases by $200 per year for the next 10 years. Calculate the equivalent annual operating cost of the machine. What will be the present and..

Common practice with expensive-high-tech equipment : You work for a nuclear research laboratory that is contemplating leasing a diagnostic scanner (leasing is a very common practice with expensive, high-tech equipment). The scanner costs $6,300,000, and it would be depreciated straight-line to zero ove..

Create an array to hold the hours and the hourly rate : Create an array to hold the hours and the hourly rate. Then print out the wages for each entry. The program should use a multi-dimensional array, a loop, and a jsr to calculate and print the values. this is in Jasmin language

Short sale margin calculations : You sell short 300 shares of Microsoft which are currently selling at $30 per share. You post the 50% margin required on the short sale. The broker requires a 30% maintenance margin.

User Account

All Pages