need help on these SQL problem(s). I have provided the that contain the database under the questions.

Complete the following exercises using the database that you have loaded in either Oracle or MySQL. Fill in the "SQL Statement" part of the chart below with the query that you use in either MySQL Workbench or Oracle Application Express. Once the query has run correctly and provided the results, take a screen snip of the results, and copy into the chart below under "Results". Answer other questions as asked. Example 1 Using IN Operator to create a subquery from two tables From your last assignment you should have a subquery that use the IN operator. Place that statement here, select steam id number, current server hours, Enum_id from rank where steam, id number in (select steam id number from staff where (team name='Admin')); SQL STATEMENT : Results: Example 2 JOINING TABLES AS ALTERNATIVE TO SUBQUERY Create the same results as #1 by JOINING TABLES. SQL STATEMENT : BALHO Dont Limit @ 1 2009 select * from account; 1. 01002 DOC Nav SCHEMAS Filter objects vijwtb_player_database Tables account Columns STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID EMAIL_ADDRESS PHONE_NUMBER DATE_OF_BIRTH Indexes Foreign Keys Triggers donations Columns STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID TEAM_NAME DONATION_AMOUNT DATE Indexes Foreign Keys Triggers limits o Columns STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID TEAM_NAME BALLOONS Result Grid Filter Rows: Edit: 3 Export/Import: Wrap Cell Content: 1A STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID EMAIL_ADDRESS PHONE_NUMBER DATE_OF_BIRTH STEAM_0:1:12438801 01001 01 carlcm01@example.com 1230260 190 01012020 STEAM_0:2:12438802 02 caricmo2@example.com 1230250390 01032020 STEAM_0:3:12438803 01030 03 carlcm03@example.com 1230240490 01042020 STEAM_0:4:12438804 01004 04 carlcm04@example.com 1230230590 01052020 STEAM_0:5:12438805 01005 05 carlcm05@example.com 1230220690 01062020 STEAM_0:6:1243880600016 06 carlcm06 @example.com 1230210790 01072020 STEAM_0:7:12438807 00007 07 carlcm07@example.com 1230200890 01082020 STEAM_0:8:12438808 00008 08 caricm08@example.com 1230 190990 01092020 STEAM_0:9:1243880900009 09 carlcm09 @example.com 1230181090 01102020 STEAM_0:1:12438810 00010 10 carlcm 10 @example.com 1230170190 01012020 STEAM_0:2:12438811 01011 11 carlcm 11@example.com 1230 160290 01022020 STEAM_0:5:12438812 00112 12 carlcm 12@example.com 1230 150390 01032020 STEAM_0:1:12438813 00013 13 carlcm 13 @example.com 1230140490 01042020 STEAM_0:6:12438814 00014 14 carlcm 14@example.com 1230130590 01052020 STEAM_0:1:12438815 00015 15 carlem 15@example.com 1230120690 01062020 STEAM_0:7:1243881600216 16 carlcm 16 @example.com 1230110190 01012020 STEAM_0:1:12438817 00017 17 carlcm 17@example.com 1230100390 01032020 STEAM_0:1:12438818 00018 18 carlcm 18 @example.com 1230090490 01042020 STEAM_0:9:12422819 00019 19 carlcm 19 @example.com 1230080590 01052020 STEAM_0:1:12438020 00320 20 carlcm 20 @example.com 1230070690 01062020 STEAM_0:5:12430821 00021 21 carlem 21 @example.com 1230060790 01072020 STEAM_0:1:12438822 00022 22 carlcm 22@example.com 1230050890 01082020 STEAM_0:4:12438823 00023 23 carlcm 23@example.com 1230040990 01092020 STEAM_0:1:12438024 00524 24 carlcm 24@example.com 1230031090 01102020 STEAM_0:9:12438825 00025 25 carlcm 25@example.com 1230020190 01012020 STEAM_0:7:12438826 00026 26 carlcm 26 @example.com 12300 10290 01022020 NULL NULL MULL Administration Schemas Information Column: ADDRESS NULL NULL NULL Collation: latin1_swedish_ci Dont Limit 1. select * from account; select * from donations; 2. SCHEMAS a Filter objects ijwtb_player_database Tables account Columns STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID EMAIL_ADDRESS PHONE_NUMBER DATE_OF_BIRTH Indexes Foreign Keys Triggers donations Columns STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID TEAM_NAME DONATION_AMOUNT DATE Indexes Foreign Keys Triggers Result Grid 1 Filter Rows: Edit: Export/Import: Wrap Cell Content: JA STEAM_ID_NUMBER CURRENT_SERVER_HOURS ENUM_ID TEAM_NAME DONATION_AMOUNT DATE STEAM_0:7:12438807 00007 07 Diamond Supporter 100.00 12-26-2020 STEAM_0:8:12438808 00008 08 Ruby Supporter 100.01 12-26-2020 STEAM_0:9:12438809 00009 09 Emerald Supporter 100.02 12-26-2020 STEAM_0:1:12438810 00010 10 Sapphire Supporter 100.03 12-26-2020 STEAM_0:2:12438811 01011 11 Crystal Supporter 100.04 12-26-2020 NULL NULL NULL NULL NULL NULL SQL File & Navigator SCHEMAS a ter objects 19 Dont Lime select from account select from donations; select * fron limits: 2. 3. 1 E Triggers limits Columns STEAM ID NUMBER CURRENT_SERVER_HOURS ENUM_ID TEAM_NAME BALLOONS BUTTONS DYNAMITE EFFECTS EMITTERS HOVERBALLS LAMPS LIGHTS NPCS PROPS RAGDOLLS SENTS SPAWNERS THRUSTERS TURRETS VEHICLES WHEELS SWEPS DATE Indexes Foreign Keys B Triggers promotions de Columns