Problem
1. Declare a variable to be used for a department ID. Do not give it an initial value.
2. Declare any other constructs needed to complete the specifics of the instructions below.
3. The first statement in your block should assign a value to the variable you declared. Use valid department IDs such as 50, 60, 85, 100, etc.
4. Using that variable, select the department name, street_address, and city from the DEPARTMENTS and LOCATIONS tables (use a join) for that department.
5. Print the information in a message using the below statement as a guide (items highlighted are dynamic).
If the department number used is invalid, print a message using the below statement as a guide (items highlighted are dynamic).
The department given 99 is an invalid department.