Remember – if you get a syntax error while copy+pasting the query, delete and retype the quotes. These queries were…