SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 5 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 09 Nov 2017 My Price 10.00

Filtering Grouping Data Summer II 2017 The due date for the assignment 7

Hi, I was wondering if you can help me out again! Please let me know!

Thanks

 

Assignment 6&7 Data Code Link: http://vizedhtmlcontent.next.ecollege.com/CAssignment 7 – Filtering Grouping Data Summer II 2017 The due date for the assignment 7 is 7/30/2017 (midnight). It must be submitted through the “Assignment 7 – Filtering Grouping Data” in Dropbox provided on the eCollege. It is important that you specify your name in the SQL file. The attachment name should follow the following convention: BUSA326_ASSIGNMENT7_FIRSTNAME_LASTNAME.SQL Import the assignment data code (skip if you did in last assignment) and use the following logical schema to answer questions below. For each question, please write comments to indicate the question you want to answer (-1 point deduction if you don’t). Note that you won’t get any credits if you use codes that haven’t learned in or before Topic 8 – Filtering Grouping Data: 1. Display date and location of tournaments which have total numbers of matches greater than 5 (1 point) 2. Display name, and highest raw scores of bowlers who have highest raw scores greater than 150 (1 point) 3. Display the first name, last name, and average raw scores of ‘Dolphins’ team members who has average raw scores greater than 150 (1 point) 4. Display the first name, last name, and average raw scores of ‘Dolphins’ team members who has average raw scores greater than average raw scores of all bowlers (1 point) 5. List the bowlers whose highest raw scores are at least 30 points higher than their current average (2 points) 6. Show the team played either in odd lane or even lane. Note: You must use UNION to get credit (2 points) 7. Name your own query question and answer it (1 point) 8. Name your own query question and answer it (1 point) The following criteria will be used to grade the assignment:  Codes are run with detail comment, accurate, and answers are correct. ***************************NOTE ************************************* Please feel free to consult your instructor by email or phone, if you have questions or need assistance!! urrentCourse/Assignment%20-%20Data%20Code.SQL

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 09 Nov 2017 07:11 AM My Price 10.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)