The Plan for Returned Orders

Easy

Description

Write a query on orders that lists the order_id and total_amount of the orders whose status is returned. Don't give the table an alias.

Instead of the orders, show the plan PostgreSQL picks for this query: only its steps, without the estimated costs. Don't run the query itself.

Easy

Write a query on orders that lists the order_id and total_amount of the orders whose status is returned. Don't give the table an alias.

Instead of the orders, show the plan PostgreSQL picks for this query: only its steps, without the estimated costs. Don't run the query itself.

QUERY PLAN
Seq Scan on orders
Filter: (status = 'returned'::order_status)

Easy

Write a query on orders that lists the order_id and total_amount of the orders whose status is returned. Don't give the table an alias.

Instead of the orders, show the plan PostgreSQL picks for this query: only its steps, without the estimated costs. Don't run the query itself.

Easy

Write a query on orders that lists the order_id and total_amount of the orders whose status is returned. Don't give the table an alias.

Instead of the orders, show the plan PostgreSQL picks for this query: only its steps, without the estimated costs. Don't run the query itself.