/SQL/How to fetch highest score in minimum time using mysql

How to fetch highest score in minimum time using mysql

SELECT gameid, 
       MIN(date) AS FirstTime, 
       MAX(date) AS LastTime,
       MAX(score) AS TOPscore.
       COUNT(*)  AS NbOfTimesPlayed 
FROM highscores
WHERE userid='2345' 
GROUP BY gameid
-- ORDER BY COUNT(*) DESC -- for ex. to have games played most at top

Source: stackoverflow.com

Similar codes

7 votes180 views2 answers
Oracle foreign key reference table
SQL
0 vote115 views1 answer
Duplicate foreign key constraint name
SQL
0 vote128 views1 answer
List all permissions on a table in postgres
SQL
0 vote120 views1 answer
List MySQL Table and Index Size
SQL
0 vote132 views1 answer
Cannot pip install mysqlclient
SQL
0 vote140 views1 answer
SQL server datetime compare
SQL
0 vote170 views1 answer
Create table as select sql server error
SQL
0 vote144 views1 answer
Sql examples from framework
SQL
0 vote139 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote130 views1 answer
Postgres float to int
SQL