Question

Create a SQL query that will update the postal code of any owner whose current postal code is 32935. Change it to 32940. After clicking Run for the query, take a screenshot of the Access window showing how many rows are about to be updated and paste it in the space provided below. DO NOT CLICK YES WITHOUT TAKING YOUR SCREENSHOT FIRST!

Answer 1

UPDATE owners

SET postal_code = '32940'

WHERE postal_code = '32935';