/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

1 vote205 views2 answers
Restart identity cascade
SQL
0 vote196 views1 answer
Mysql update privileges
SQL
0 vote208 views1 answer
Except in sql
SQL
0 vote204 views1 answer
Drop index in sql
SQL
0 vote204 views1 answer
Set mysql socket file docker windows
SQL
22 votes212 views4 answers
Mysql reset auto increment id
SQL
2 votes216 views1 answer
Sql OR
SQL
0 vote205 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote246 views1 answer
Python dictionary to sql update
SQL
1 vote218 views1 answer
Expression number 1 of select list is not in group by clause
SQL