[Mysql] Group by date passaggio 5 a 8

[pippuccio76]

prova con

SELECT
    numero_scheda,
    user_id,
    MAX(date) AS date
FROM  
    lavorazioni 
WHERE 
    date>='2022-01-01'   
GROUP BY  
    numero_scheda,
    user_id 
ORDER BY 
    MAX(date) DESC

Funziona Grazie