Which one of the following statements allows for variable substitution?
A.
$sql=qq{SELECT * FROM MyDatabase WHERE state=’$state’};
B.
$sql=q{SELECT * FROM MyDatabase WHERE state=’$state’};
C.
$sql=q{SELECT * FROM MyDatabase WHERE state=$state};
D.
$sql=qq{SELECT * FROM MyDatabase WHERE state=$state};