The correct answer is: B. Select

A select query is a query that retrieves data from one or more tables in a database. The results of a select query are displayed in a table.

A parameter query is a query that allows you to enter a value when you run the query. The value you enter is used to filter the results of the query.

A crosstab query is a query that summarizes data in a table. The results of a crosstab query are displayed in a table with columns and rows.

Here is an example of a select query:

sql SELECT * FROM Customers;

This query will retrieve all rows and columns from the Customers table.

Here is an example of a parameter query:

sql SELECT * FROM Customers WHERE City = @City;

This query will retrieve all rows from the Customers table where the City column is equal to the value you enter for the @City parameter.

Here is an example of a crosstab query:

sql SELECT CustomerName, City, COUNT(*) AS Total FROM Customers GROUP BY CustomerName, City;

This query will summarize the number of customers by city. The results will be displayed in a table with columns for CustomerName and City, and a row for the total number of customers in each city.