(oracle)apply some sql quries

- Sub queries - Conditional restrictions - Arithmetic operators - Logical operators - Special operators - Order the output - Aggregate Functions - Group by / Having - SQL functions

to this data

\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_cade \\ \hline Rdt & 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 & R.14 & Re3 \\ \hline Rd2 & Thirteen & 19:00:00 & 19:30:00 & R.17 & 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 Rc1 & RoomI & Gamel & Idl \\ \hline Rc21 & Room2 & Game2 & Id2 \\ \hline Rc3 & RoomI & 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 & 6 manarr & 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_ID & 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 Log3 & 16:00:11 & 16:59:59 & Id2 \\ \hline Log4 & 08:23:34 & 10:09:08 & Id5 \\ \hline Log5 & 22:41:09 & 23:35:55 & Id1 \\ \hline Log6 & 13:08:00 & 13:54:59 & Id4 \\ \hline \end{tabular}