I am really sorry if you get the wrong idea. I do not want you to make SQL queries. I know how to do that. I explained the table just so you can understand the table schema.
What i am having problem is with converting the SQL queries into Jooq Here are the two queries 1. select count(GAME_ID)+1 AS 'MAXSCORE_ID' from GAME 2. update GAME set END_TIME=now(), PLAY_TIME=TIMESTAMPDIFF(SECOND,START_TIME,END_TIME) where GAME_ID="100001"
