Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Aggregate functions

Ratings

Report a typo

Write a query that returns average users_rating and critics_rating for games with both ratings higher than or equal to 8 points. The table name is games.

title publisher developer users_rating critics_rating
Vanguards Art of Electro Diamond Games 8.6 8.2
Hooligans 14 Macrofiber Turn 9 Studios 8.5 8.4
Ship Simulator 2 Yson Giraffe Tongue 7.3 7.6
Call of Honor Art of Electro Anvil & Hammer 6.8 6.8
Bridges Kamino Toroto Productions 9.6 9.3
Write an SQL statement





___

Create a free account to access the full topic