Express the following natural language queries in SQL(Oracle):

Check if the room MB316 is free on Friday at 16:00. If the room MB316 is free on that day and time, this query shows the room MB316 as a result, otherwise the query shows nothing.

(Hint: Use subquery and SUBSTR(string_variable, starting_point, number_of_characters) ).

No need to rush. I need correct answer.

Given the following three tables, namely, Lecturer, Assignment and Module Position 1 King Road Paul Cooper Professor James Car1son Asso Professor 2 queen Road Ann Stephens Professor 3 Prince Road 4 Waters Street 48 Professor Patrick wood Asst Professor 5 Flare Street oyce Lee Kevin Martin Lecturer Malcolm Moore Lecturer 6 Peterson Road 25 7 Robinson Road 26 8 university Road 24 Lecturer Table1: Lecturer ASSIGNID NAME TIME DURATION ROOM 1 Paul cooper BS224 Friday 2 James Car1son BS224 Wednesday 10:00 3 James Carlson BS123 Friday 4 Ann Stephens CS112 Friday 5 Ann Stephens Cs174 Monday 6 Ann Stephens CS236 Friday 16:00 7 Peter chan 8 Patrick Wood CS112 Friday 11:00 9 Patrick Wood CS236 Friday 13:00 120 AC224 5 120 MB316 120 MB316 120 ST311 120 PQ621 CS236 Tuesday 16:00 C3112 rriday CS236 Tuesday 09:00 EE332 Monday 10 Joyce Lee 11 Joyce Lee 12 Joyce Lee 13 Kevin Martin cs112 Wednesday 16:0O 14 Malcolm Moore CS236 Monday 15 Malcolm Moore EE332 Friday Code Name Credits Type BS123 Management BS224 Marketing CS112 Programming CS174 Internet CS236 Databases EE332 Electronics Table3: Module