WEEKLY CHALLENGE 4

The column labels in row 1 are attributes that refer to the data in the column. An attribute is a characteristic or quality of data used to label a column in a table.

The clause FROM employee will retrieve the data from the employee table. The complete query is SELECT * FROM employee. The FROM clause specifies which database table to select data from. The employee Nancy Edwards has the job title of Sales Manager.

The clause WHERE customer_id = 35 will return only data about the customer with ID number 35. The complete query is SELECT * FROM invoice WHERE customer_id = 35. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The billing country for the customer with ID number 35 is Portugal.

This is a line chart. Line charts are effective for illustrating trends and patterns, such as how population changes over time.

This is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.

The column attributes for rank, name, population, and county are located in row 1. An attribute is a characteristic or quality of data used to label a column in a table.

The observation of Greensboro describes all of the data in row 4. An observation is all of the attributes for something contained in a row of a data table.

Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.

The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.

The chart editor enables data analysts to choose the type of chart you're making and customize its appearance.

Sort range would be used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.

The correct AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.

The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.

These words are attributes, referring to the information in the columns below. An attribute is a characteristic or quality of data used to label a column in a table.

Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.

The clause WHERE customer_id = 28 will return only data about the customer with ID number 28. The complete query is SELECT * FROM invoice WHERE customer_id = 28. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The billing city for the customer with ID number 28 is Salt Lake City.

Line charts are effective for illustrating trends and patterns, such as how something changes over time.

The observation for Fayetteville is in row 7. An observation is all of the attributes for something contained in a row of a data table.

The clause FROM playlist will retrieve the data from the playlist table. The complete query is SELECT * FROM playlist. The FROM clause specifies which database table to select data from. The playlist with ID number 3 is TV Shows.

The clause FROM genre will retrieve the data from the genre table. The complete query is SELECT * FROM genre. The FROM clause specifies which database table to query. The name of the genre with ID number 3 is Metal.