Layer 1
Ask Questions

You are querying a database that contains data about music. You are only interested in data related to the jazz musician Miles Davis. The names of the musicians are listed in the composer column.

You write the SQL query below. Add a WHERE clause that will return only data about music by Miles Davis.

SELECT 
*
FROM 
track
Correct
The clause WHERE composer = "Miles Davis" will return only data about music by Miles Davis. The complete query is SELECT * FROM track WHERE composer = “Miles Davis”. 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 track Now's The Time by Miles Davis appears in row 1 of your query result.

Related Questions & Answers:

  1. Which of the following is a benefit of internal data? 4. Which of the following is a benefit of internal data? 1 / 1 point  Internal data is more reliable and easier ... Read more...
  2. Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply. 1. Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply. 1  ... Read more...
  3. A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario? 2. A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of ... Read more...
  4. You notice that the data in column E is an example of Boolean data. Why did you come to this conclusion? 2. Scenario 1 continued Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction ... Read more...
  5. Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst should take the initiative to do so without involving others in order to be respectful of their time. 8. Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst ... Read more...
  6. Fill in the blank: Data analysts usually use _____ to deal with very large datasets. 1. Fill in the blank: Data analysts usually use _____ to deal with very large datasets. 1 / 1 point ... Read more...