___________ clause is used to retrieve data from one or more tables?Select one:WhereOrder bySelectHaving

What is the purpose of the WHERE clause in a SQL query?Select one:a. To specify the order of the resultsb. To group rows into subsetsc. To specify the columns to be retrievedd. To filter rows based on a condition

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.Where, fromSelect, fromFrom, whereFrom, select

What is the purpose of the WHERE clause in an SQL statement?To specify the columns to be retrievedTo specify the table to be queriedTo filter records based on specified conditionsTo sort the retrieved data

In the following query, which clause indicates the table from which to retrieve data?SELECT *FROM GardenWHERE herb = 'basil'

The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.