Question

1. you are writing a sql query to filter data from a database that describes trees in omaha, nebraska. you want to only display entries for trees that have a diameter of 30 inches. the name of the table you’re using is nebraska_trees and the name of the column that shows the diameters of the trees is trunk_diameter. what is the correct query syntax that will retrieve and filter data from this table?

○ select nebraska_trees where trunk_diameter = 30
○ select trunk_diameter = 30 from nebraska_trees
○ select * from trunk_diameter where nebraska_trees = 30
○ select * from nebraska_trees where trunk_diameter = 30

Explanation:

SQL queries follow the structure: SELECT (columns) FROM (table) WHERE (condition). To get only the trunk_diameter column for trees with 30-inch diameter, we specify the column name in SELECT, the table name in FROM, and the filter condition in WHERE.

Answer:

SELECT trunk_diameter = 30 FROM Nebraska_trees