/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 vote372 views5 answers
Mode sql course
SQL
0 vote338 views1 answer
Excute raw query
SQL
0 vote301 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote338 views1 answer
Sum values by month mariadb
SQL
0 vote338 views1 answer
Mysql set boolean default value
SQL
-1 vote396 views4 answers
Full outer join in sql
SQL
0 vote376 views1 answer
Sparql list all graphs
SQL
0 vote343 views2 answers
Sql query for getting details by id
SQL
0 vote349 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote344 views1 answer
Oracle create as select
SQL