---

You are writing a PROC SQL query to display the names of all library cardholders who work as volunteers for the library, and the number of books that each volunteer currently has checked out. Use one or both of the following tables:
? Certadv.Circulation lists the name and contact information for all library cardholders, and the number of books that each cardholder currently has checked out.
? Certadv.Volunteers lists the name and contact information for all library volunteers.
Assume that the values of Name are unique in both tables.
Which of the following PROC SQL queries will produce your report?

proc sql;
    select name, checkedout
    from certadv.circulation
    where * in
    (select *
    from certadv.volunteers);
quit;

proc sql;
    select name, checkedout
    from certadv.circulation
    where name in
    (select name
    from certadv.volunteers);
quit;

proc sql;
    select name
    from certadv.volunteers
    where name, checkedout in
    (select name, checkedout
    from certadv.circulation);
quit;

proc sql;
    select name, checkedout
    from certadv.circulation
    where name in
    (select name
    from certadv.volunteers);
quit;