i want to applay those sql queries (oracle)

on the data below use as much as you can

- Sub queries - Join - Conditional restrictions - Arithmetic operators - Logical operators - Special operators - Order the output - Aggregate Functions - Group by / Having - SQL functions \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ User } \\ \hline User_id & User_name & User_pass & User_email & User_level & User_gender \\ \hline Id1 & Farrah & 123f123 & Fa@fire.com & 12 & female \\ \hline Id2 & Mozn & 9887mm & Mozn@gmail.com & 6 & female \\ \hline Id3 & Layan & 11ayan1 & 11 layan@pro.com & 8 & female \\ \hline Id4 & Manar & 6 manarr & manar@tay.com & 4 & female \\ \hline Id5 & Ghaida & 111g888 & g1g@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 & Id1 \\ \hline Log2 & 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} \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{4}{|c|}{ room } \\ \hline Room_code & Room_id & Game_id & User_id \\ \hline Rc1 & Room1 & Gamel & User1 \\ \hline Rc21 & Room2 & Game2 & User3 \\ \hline Rc3 & Room1 & Game3 & User1 \\ \hline Rc92 & Room4 & Game4 & User5 \\ \hline \end{tabular}