Question

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Answer 1

Structured Language Query ( SQL ) query helps retrieving the data by using its SELECT keyword which specifies the table name to select while retrieving data.

By using where clause you can filter data as well. Also it has aggregate functions to help development like sum() function. And it can format the data to be displayed as well.

Answer 2

A Structured query has clauses to retrieve data, filter those to get the desired output.

Select clause --> specifies the list column(s) that need to be selected and displayed

From clause--> contains the table(s) from which the data needs to be fetched

Where clause--> this contains the condition or the filter that needs to be made on the retrieved data before display

Group by --> to display data with sub-total, grand total or any grouping related activities

Having-->this is similar to where clause but this works on grouping.

Order by --> to sort the filtered data in ascending (asc) or descending(desc) order.