/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

0 vote280 views1 answer
Sql pivot table
SQL
1 vote302 views1 answer
Oracle plan hash value
SQL
1 vote271 views2 answers
Test sqlsrv connection
SQL
0 vote278 views1 answer
Sql delete caracter list
SQL
10 votes267 views1 answer
Oracle dba_dependencies
SQL
2 votes271 views1 answer
Oracle list grants on package
SQL
3 votes263 views2 answers
Current year sql
SQL
1 vote279 views1 answer
Oracle select row max date
SQL
0 vote285 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote259 views2 answers
Mysql to python pandas
SQL