Iterate on your first query

In this exercise, you will go back to your original SQL query and make changes.

You now feel comfortable working with ease using the SQL Editor in Databricks. You have had a new request come to you from one of the other departments. They are interested in knowing how many books have been published per year since 1980. You will use your existing query as the base and carry out the necessary updates to find the answer.

We do not recommend doing so, but if you lost progress, you will have to recreate the data table bx_books_file using the information in the Adding your datasets exercise and recreate the first SQL query using the information in the Write your first query exercise.