/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 vote191 views1 answer
Mac mysql workbench console
SQL
49 votes333 views6 answers
Install mysql ubuntu
SQL
0 vote183 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote226 views1 answer
MySQL get all previous date record
SQL
4 votes193 views1 answer
Oracle show errors
SQL
5 votes287 views4 answers
Sql check
SQL
4 votes202 views1 answer
Id increment ms sql server
SQL
4 votes196 views5 answers
Primary key
SQL
4 votes193 views2 answers
Show all database inside postgresql
SQL
-1 vote212 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL