I need a procedure which takes input of the parent table name and in turn drops the table and its child tables from the DB.

Write SQL query to find the department (prompt from user (optional)) whose employees decreased in 1996 compared to 1995

What are the link types for joins, =? What datasets result? I cannot find anything about these link types online or in Help.