ParthModi's avatar

SQL Query

https://prnt.sc/MdiX5BHyyxnD

I have above table record with same user_id and chapter_id now I want record like

  1. group by level
  2. get max correct_answer record (if user_id, chapter_id and level and correct ans is one record)
  3. if ( user_id, chapter_id and level ) are same and correct answer more then one record then given me lowest best_time record
0 likes
0 replies

Please or to participate in this conversation.