If a view is created as CREATE VIEW recent_orders AS SELECT * FROM orders WHERE order_date > current_date - interval '7 days', what will SELECT COUNT(*) FROM recent_orders; return?

medium📝 query result Q5 of 15

PostgreSQL - Views and Materialized Views

If a view is created as CREATE VIEW recent_orders AS SELECT * FROM orders WHERE order_date > current_date - interval '7 days', what will SELECT COUNT(*) FROM recent_orders; return?

AThe number of orders placed in the last 7 days

BThe total number of orders in the table

CAn error because interval syntax is invalid

DZero, because views do not store data

Step-by-Step Solution

Solution:

Step 1: Understand the view filters orders by recent dates
The view selects orders with order_date within the last 7 days.
Step 2: COUNT(*) on the view counts matching rows
The query counts how many orders satisfy that date condition.
Final Answer:
The number of orders placed in the last 7 days -> Option A
Quick Check:
View filters recent orders = C [OK]

Quick Trick: COUNT on a view counts rows matching its query [OK]

Common Mistakes:

Confusing view with stored data
Thinking interval syntax is wrong
Assuming COUNT returns total table rows

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

If a view is created as CREATE VIEW recent_orders AS SELECT * FROM orders WHERE order_date > current_date - interval '7 days', what will SELECT COUNT(*) FROM recent_orders; return?

Step 1: Understand the view filters orders by recent dates

Step 2: COUNT(*) on the view counts matching rows

Final Answer:

Quick Check:

Want More Practice?