Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

 

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)

Step by Step Solution

3.29 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

Answer Based on the given in the ab... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students explore these related Databases questions