You work for a retail clothing store. You have been asked to create a table of items that are on 50 percent clearance. Which query should you run to accomplish this task?

An action query can create or change database objects and records. A make-table query is a type of action query, so it can create a table containing the items on 50 percent clearance. A parameter query prompts for a value, while a crosstab query summarizes data in a row-and-column layout.

AI-written and checked against the verified answer.