apply some sql queries

(Sub queries - Join - Conditional restrictions - Arithmetic operators - Logical operators - Special operators - Order the output - Aggregate Functions - Group by / Having )

to this data

\begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ REWARD } \\ \hline Reward name & Rewurd id & Reward level & Reward prize & Reward descrintion \\ \hline Re15 & R12 & 1 & Threehundredpoints & brilliant \\ \hline Re216 & R13 & 2 & two hundred & brilliant \\ \hline Re34 & R14 & 3 & fivehundredpoints & brilliant \\ \hline Re922 & R17 & 4 & Threehundredpoints & brilliant \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ RESULT } \\ \hline Result_id & Result_score & Result_start_time & Result_end_time & Reward_id & Room_code \\ \hline Rdl & ten & 17:00:00 & 17:30:00 & R12 & Rel \\ \hline Rd21 & eleven & 20:00:00 & 20:30:00 & R13 & Re21 \\ \hline Rd3 & twelve & 18:00:00 & 18:30:00 & R14 & Re3 \\ \hline Rd2 & Thirteen & 19:00:00 & 19:30:00 & R17 & Re92 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Room_information } \\ \hline Room_id & Room_name \\ \hline Room1 & Power \\ \hline Room2 & Friends \\ \hline Room3 & Nerds \\ \hline Room4 & Fam \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ room } \\ \hline Room_code & Room_id & Game_id & User_id \\ \hline Rcl & Room1 & Gamel & Idl \\ \hline Rc21 & Room2 & Game2 & Id2 \\ \hline Rc3 & Room1 & Game3 & IdI \\ \hline Rc92 & Room4 & Game4 & Id3 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ User } \\ \hline User id & User_name & User_pass & User_email & User_level & User_gender \\ \hline Id1 & Farrah & 123f23 & Fa@fire.com & 12 & female \\ \hline Id2 & Mozn & 9887mm & Mozn@gmail.com & 6 & female \\ \hline Id3 & Layan & 1 layan1 & 11layan@pro.com & 8 & female \\ \hline Id4 & Manar & 6manarr & manar@tay.com & 4 & female \\ \hline Id5 & Ghaida & 111g888 & glg@good.com & 10 & female \\ \hline Id6 & Fahad & fahad3 & Fahad@hotmail.com & 1 & male \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ LOG } \\ \hline LOG_II & LOGIN_TIME & Logout_time & User_id \\ \hline Log1 & 03:11:02 & 04:22:00 & IdI \\ \hline Log 2 & 11:35:55 & 12:44:22 & Id3 \\ \hline Log 3 & 16:00:11 & 16:59:59 & Id2 \\ \hline Log4 & 08:23:34 & 10:09:08 & Id5 \\ \hline Log5 & 22:41:09 & 23:35:55 & IdI \\ \hline Log6 & 13:08:00 & 13:54:59 & Id4 \\ \hline \end{tabular}