List the teamID, team name, and the first name, last name and the name of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
List the teamID, team name, and the first name, last name and the name of the country for the gamer(s) with the most team points for each team. Use a correlated sub-query on the teamID column. There might be more than one maximum!!! For example: Result teamID 1 2 3 4 5 6 7 8 9 10 11 12 13. 14 15 16 17 18 19 20 22222222223 21 24 25 26 27 28 29 30 teamName firstName lastName AngryCreepy591 Colton AngryCreepy591 Wilber PsychoYellow15 Synthia CreepyNugget01 Lyn CreepyOtter314 Augusta AngryBurger618 Lyn SealAlpha875 Timmy Red Yellow907 Elene SaladAngry054 Tawna GammaNugget130 Zella OtterBurger641 Kendrick Redotter070 Lee HappyFlying007 Nicholas CreepyAngry842 Jospeh CrazySalad640 Leandro YellowRed567 Hae BetaBeta970 Erica FlyingNugget 32 Gerardo BlueGreen431 PsychoCreepy99 CrazyRed311 BlueNugget209 Gail NuggetCrazy125 Rex Darrick OtterAngry364 Vicente Shealy NuggetShark988 Margit Fenner Donny Eldon Laurinda Barbieri Mogan Brewton Mccluney Roldan Mogan Perrino Purpura Ralls Boughton Barry Matthew Bhakta Sansone Rachel Landis Hooton Woolery Buller Buller Beckner Villescas Correia RedAlpha714 Nievesnet Boughton CreepyBurger55 Carter Laursen CreepyCreepy67 Eilene SealCreepy777 Delena Psycho0tter262 Trinidad Hansen Delena Matthew RedAlpha076 Keegan name Ethiopia Japan Iran Vietnam Thailand Bangladesh India Turkey Germany United Sta Thailand Ethiopia Russia Pakistan Indonesia Bangladesh India Bangladesh Bangladesh Ethiopia Philippine Mexico. Vietnam Thailand China Turkey Philippine Indonesia China China Vietnam Country (countryID, name, population) PRIMARY KEY (countryID) Publisher (pubID, name, revenue, countryID) PRIMARY KEY (pubID), FOREIGN KEY (countryID) references Country (countryID) AgeRating (arID, label, minAge) PRIMARY KEY (arID) Genre (genreID, label) PRIMARY KEY (genreID) Console (consoleID, consoleName) PRIMARY KEY (consoleID) Team (teamID, teamName) PRIMARY KEY (teamID) Gamer (gamer ID, firstName, lastName, birthYear, gender, country ID, teamID, teamPoints) PRIMARY KEY (gamerID), FOREIGN teamID) references Team(teamID), FOREIGN KEY (countryID) references Country(countryID) Game (gameID, title, pubID, arID, genreID) PRIMARY KEY (gameID), FOREIGN KEY (pubID) references Publisher (pubID), FOREIGN KEY (arID) references AgeRating (arID), FOREIGN KEY (genreID) references Genre(genreID) Purchase (purchase ID, purchaseDate, cost, game ID, console ID, gamer ID, PRIMARY KEY (purchaseID), FOREIGN KEY (game ID) references Game (gameID), FOREIGN KEY (consoleID) references Console (consoleID), FOREIGN KEY (gamerID) references Gamer (gamerID) GameRating (game ID, gamer ID, ratingDate, rating) PRIMARY KEY (gameID, gamer ID, ratingDate), FOREIGN KEY (gamerID) references Gamer (gamer ID), FOREIGN KEY (gameID) references Game (gameID) Game Release (game ID, console ID, relaseDate, relaseCost) PRIMARY KEY (game ID, consoleID), FOREIGN KEY (consoleID) references Console (consoleID), FOREIGN KEY (game ID) references Game (gameID) List the teamID, team name, and the first name, last name and the name of the country for the gamer(s) with the most team points for each team. Use a correlated sub-query on the teamID column. There might be more than one maximum!!! For example: Result teamID 1 2 3 4 5 6 7 8 9 10 11 12 13. 14 15 16 17 18 19 20 22222222223 21 24 25 26 27 28 29 30 teamName firstName lastName AngryCreepy591 Colton AngryCreepy591 Wilber PsychoYellow15 Synthia CreepyNugget01 Lyn CreepyOtter314 Augusta AngryBurger618 Lyn SealAlpha875 Timmy Red Yellow907 Elene SaladAngry054 Tawna GammaNugget130 Zella OtterBurger641 Kendrick Redotter070 Lee HappyFlying007 Nicholas CreepyAngry842 Jospeh CrazySalad640 Leandro YellowRed567 Hae BetaBeta970 Erica FlyingNugget 32 Gerardo BlueGreen431 PsychoCreepy99 CrazyRed311 BlueNugget209 Gail NuggetCrazy125 Rex Darrick OtterAngry364 Vicente Shealy NuggetShark988 Margit Fenner Donny Eldon Laurinda Barbieri Mogan Brewton Mccluney Roldan Mogan Perrino Purpura Ralls Boughton Barry Matthew Bhakta Sansone Rachel Landis Hooton Woolery Buller Buller Beckner Villescas Correia RedAlpha714 Nievesnet Boughton CreepyBurger55 Carter Laursen CreepyCreepy67 Eilene SealCreepy777 Delena Psycho0tter262 Trinidad Hansen Delena Matthew RedAlpha076 Keegan name Ethiopia Japan Iran Vietnam Thailand Bangladesh India Turkey Germany United Sta Thailand Ethiopia Russia Pakistan Indonesia Bangladesh India Bangladesh Bangladesh Ethiopia Philippine Mexico. Vietnam Thailand China Turkey Philippine Indonesia China China Vietnam Country (countryID, name, population) PRIMARY KEY (countryID) Publisher (pubID, name, revenue, countryID) PRIMARY KEY (pubID), FOREIGN KEY (countryID) references Country (countryID) AgeRating (arID, label, minAge) PRIMARY KEY (arID) Genre (genreID, label) PRIMARY KEY (genreID) Console (consoleID, consoleName) PRIMARY KEY (consoleID) Team (teamID, teamName) PRIMARY KEY (teamID) Gamer (gamer ID, firstName, lastName, birthYear, gender, country ID, teamID, teamPoints) PRIMARY KEY (gamerID), FOREIGN teamID) references Team(teamID), FOREIGN KEY (countryID) references Country(countryID) Game (gameID, title, pubID, arID, genreID) PRIMARY KEY (gameID), FOREIGN KEY (pubID) references Publisher (pubID), FOREIGN KEY (arID) references AgeRating (arID), FOREIGN KEY (genreID) references Genre(genreID) Purchase (purchase ID, purchaseDate, cost, game ID, console ID, gamer ID, PRIMARY KEY (purchaseID), FOREIGN KEY (game ID) references Game (gameID), FOREIGN KEY (consoleID) references Console (consoleID), FOREIGN KEY (gamerID) references Gamer (gamerID) GameRating (game ID, gamer ID, ratingDate, rating) PRIMARY KEY (gameID, gamer ID, ratingDate), FOREIGN KEY (gamerID) references Gamer (gamer ID), FOREIGN KEY (gameID) references Game (gameID) Game Release (game ID, console ID, relaseDate, relaseCost) PRIMARY KEY (game ID, consoleID), FOREIGN KEY (consoleID) references Console (consoleID), FOREIGN KEY (game ID) references Game (gameID)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
You are required to apply the knowledge garnered throughout the course to hypothetical scenarios, as well as, to support these scenarios with relevant case laws on the subject matter, international...
-
Ayayai Company prepares its statement of cash flows using the direct method for operating activities. For the year ended December 31, 2024, Ayayai Company reports the following: Sales on account...
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
16. Read each brief description of a project in the following table and classify its type according to the Obeng model (Fog, Quest, Movie, Paint by Numbers (PBN)). (5) Project Reduce the cost of...
-
A projectile is launched from point A with an initial velocity v0 of 120 ft/s at an angle of 30? with the vertical. Determine the radius of curvature of the trajectory described by the projectile(a)...
-
Derive Equation 26.12 for the field E(vector) dipole in the plane that bisects an electric dipole. 1 dipole 4TE, r3
-
The probability that the first stage of a numerically controlled machining operation for high-rpm pistons meets specifications is 0.90 . Failures are due to metal variations, fixture alignment,...
-
What does it mean to adopt a maturity matching approach to financing assets, including current assets? How would a more aggressive or a more conservative approach differ from the maturity matching...
-
On December 31, 2023, Berclair Incorporated had 400 million shares of common stock and 7 million shares of 9%, $100 par value cumulative preferred stock issued and outstanding. On March 1, 2024,...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
When a physicist says that an object is in equilibrium, what this means is: The object can be balanced on one fingertip The forces acting on the object add up to zero The forces acting on the object...
-
(a) In the short run, it is argued that production occurs only in stage II. What is this stage II and why is it so important in production? Illustrate Using a diagram. (9marks)
-
Given a demand function for a monopoly firm as p=20-q and cost function as C=q +8q+2 (a) What output level maximizes total profit and what are the corresponding values of price, profit and total...
-
(a) What are the causes of monopoly? Is monopoly desirable? (8marks) (b) With the use of examples, differentiate between positive and normative economics (5marks) (c) Differentiate between movements...
-
(a) State the difference between explicit and implicit costs of production and geometrically derive average and marginal products. (8marks) (b) Describe the features of a perfectly competitive market...
-
Total Product (Q) a) Given the following information for Kamaguta Traders. Total Fixed Cost Total Variable Costs (TFC) (TVC) 0 100 0 1 100 90 2 100 170 3 100 240 5 45 100 300 100 370 6 100 450 7 100...
-
Based on your answer to Part B, what is the average rate of formation of HCl? Now consider the following reaction and data: H 2 +2ICl2HCl+I 2 Time (s) I2 concentration ( M ) 5 1.45 15 1.90 Part B:...
-
The electric field due to a line charge is given by where l is a constant. Show that E is solenoidal. Show that it is also conservative. E =
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
Your supervisor has asked you to research the following situation concerning Owen and Lisa Cordoncillo. Owen and Lisa are brother and sister. In May 2012, Owen and Lisa exchange business pickup...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
An open drainage canal with a rectangular cross section is $3 \mathrm{~m}$ wide and $1.5 \mathrm{~m}$ deep. If the canal slopes $950 \mathrm{~mm}$ in $1 \mathrm{~km}$ of length, what is the maximum...
-
You must design and specify equipment for transporting $100 %$ acetic acid (density $=1000 \mathrm{~kg} / \mathrm{m}^{3}$, $\mu=1 \mathrm{mPa}$ s), at a rate of $11.3 \mathrm{~m}^{3} / \mathrm{h}$,...
-
The Alaskan pipeline was designed to carry crude oil at a rate of 1.2 million $\mathrm{bbl} / \mathrm{day}(1 \mathrm{bbl}=$ $42 \mathrm{gal})$. If the oil is assumed to be Newtonian, with a viscosity...
Study smarter with the SolutionInn App