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?

In this activity, you used JOIN statements to combine data from multiple tables. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions.Why do you think JOIN statements are important for working with databases? What are the consequences of choosing the wrong type of JOIN for your application?For what types of activities will aliasing be most useful?

(40-60 words) in response to each of the following questions.Why do you think JOIN statements are important for working with databases? What are the consequences of choosing the wrong type of JOIN for your application?For what types of activities will aliasing be most useful?

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

Which elements of a temporary join table have a major impact on query performance? Select TWO correct answers.A. Table sortingB. Number of columnsC. Existence of table statistic

If a temporary table contains custom fields not essential for joins with other tables, you should place these fields at the beginning of the CREATE TABLE statement.A.TrueB.False