Some help with thus subquery question, the solution must use the 'IN' operand. thanks!

The Rental Store's management wants a report that lists all details of members who returned their rented DVDs late. Your results should look like this. Note that your query should contain at least one subquery] MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM CITY MEM_STATE MEM ZIP TAMI DAWSON 2632 TAKLI CIRCLE NORENE TN 37136 110 LEWIS ROSALES 4524 SOUTHWIND CIRCLE COUNCE TN 38326 MEM BALANCE 102 11.00 0.00 price table contains the rental fee and dally late fee for various kinds of movie collections eg. New Release Discount, Standard etc. . movie table contains the details of a movie such as its title, genre and the year it was released. Note that there could be multiple dvds of a movie and details of each dvd is stored in the video table membership table contains details of members who can tent videos rental table contains details of each rental Note that several movies lie their avd videos) can be rented by a member on one rental. The detall of each video rented including the due date, tee and late fee for that rental is included in the detaltrental table price PRICE_CODE DECIMAL(2,0) PRICE DESCRIPTION VARCHAR(20) PRICE_RENTFEE DECIMAL(5,2) PRICE_DAILYLATEFEE DECIMAL(5,2) movie MOVIE_NUM DECIMAL(8,0) MOVIE TITLE VARCHAR(75) MOVIE YEAR DECIMAL(4,0) MOVIE COST DECIMALS,2) MOVIE GENRE VAROWAR(SO) PRICE_CODE DECIMAL(2.0) Indexes video VID NUM DECIMAL(8,0) VID INDATE DATE MOVIE NUM DECIMAL(8,0) Index Video Rental Database (Videorental_db.sal) membership MEM_NUM DECIMAL(8,0) MEM FNAME VARCHAR(30) MEM LNAME VARCHAR(30) MEM STREET VARCHAR(120) MEM CITY VARCHAR(50) MEM STATE CHAR(2) MEM ZIP CHAR(5) MEM BALANCE DECIMAL(10,2) rental RENT NUM DECIMAL(8,0) RRENT DATE DATE MEM NUM DECIMAL(8,0) Indexes detailrental RENT NUM DECIMAL(8,0) VID NUM DECIMALI8,0) DETAIL FEEDECIMAL(5,2) DETAIL DUEDATE DATE DETAIL RETURNDATE DATE DETAIL DAILYLATEFEE DECIMAL(5,2)