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};