List the total number of games that have a genre with the label of 'Shooter! Use...

 

Transcribed Image Text:

List the total number of games that have a genre with the label of 'Shooter! Use subqueries and IN clauses. Rename the total number column to 'Total Number of Shooter Games' For example: Result Total Number of Shooter Games 17 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 total number of games that have a genre with the label of 'Shooter! Use subqueries and IN clauses. Rename the total number column to 'Total Number of Shooter Games' For example: Result Total Number of Shooter Games 17 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)

Answer rating: 100% (QA)

SQLite query List the total number of games that have a genre with the label of Shooter Use subqueries and IN clauses Rename the total number column t... View the full answer