Activity Overview As data calculations become more complicated, there are many components to keep track of, such as range, cost, time elements, products, and more. Some people use sticky notes for this, while others use checklists. In the data profession, a temporary table is just like a sticky note. You learned about temporary tables in SQL in earlier lessons, so take a moment to review. Temporary tables, or temp tables, store subsets of data from standard data tables for a certain period of time. Temp tables allow you to run calculations in temporary data tables without needing to make modifications to the primary tables in your database. Because they are temporary, they are automatically deleted at the end of your SQL session. By the end of this activity, you will have gained more experience creating temp tables and using them to run queries. Review the following scenario. Then complete the step-by-step instructions. A bikeshare company has reached a milestone, and their marketing team wants to write a blog post announcing the popularity of their most-used bike. They want to include the name of the station where that bike can most likely be found, so they ask you to determine which bike is used most often. 1. Question 1 Reflection How would you change the query to find the least frequent starting station of the bike ridden for the most time? Choose the correct code revision. 0 / 1 point 123 -- In the second occurrence of ORDER BY: ORDER BY trip_ct ASC 3 -- In the first occurrence of ORDER BY: ORDER BY trip_duration ASC 52341 ORDER BY trip_duration ASC ... ORDER BY trip_ct ASC 312 SELECT bike_id, MIN(duration_minutes) AS trip_duration

Question 2In this activity, you created a temporary table to run calculations without needing to make modifications to the primary tables in your database. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:Why was the JOIN statement necessary to use in this activity? What is the benefit of executing a query in a temporary table rather than a primary table in a database?

What are temporary tables, and how can they be used to optimize queries?Review LaterTemporary tables are permanent tables used to store intermediate results in a database.Temporary tables are used to store metadata about the database schema.Temporary tables are tables created and used within a single session or transaction.Temporary tables are used to encrypt sensitive data in a database.

Question 4Why might a data professional add a CREATE TABLE statement to a temporary table?1 pointInclude metadata about the data in the tableGive multiple people access to the tableCreate a second table within the temporary tableAutomate calculations in the table

In this activity, you learned how to analyze data using spreadsheet functions. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:How does using functions to make calculations help you quickly gain insights into large amounts of data?How does creating a data table help you organize and communicate important aspects of your data?

The average adult makes thousands of conscious decisions each day. Think about how many of those are data-driven decisions, such as the ones you’ve been learning about. Data surrounds your everyday activities. The daily weather report contains data, and so does a sign listing your local convenience store’s hours. If you think about it, you base your decisions on available data all the time, whether you're checking the weather report to decide what to wear or looking up store hours to know what time to shop. For each task listed below, what data is available to help make decisions related to the task? For example, item prices are pieces of data available for deciding how to spend money.When to wake up Whether to go out to eatWhat to spend money onWhat to listen to on the radioWho to call on the phone