08-postgresql-features-exercises.sql

-- Exercise 08: PostgreSQL-Specific Features
-- Write your answers below each question.

-- 1. Insert one loss-making superstore row into lesson_order_reviews and use RETURNING.

-- 2. Use INSERT ... ON CONFLICT to update the review_status for an existing row_id.

-- 3. Use generate_series() to return every date from 2017-06-01 to 2017-06-05.

-- 4. Write one query that uses FILTER to show:
--    total orders, profitable orders, and total sales in the South region.

-- 5. Use DISTINCT ON to return the latest order for each customer_id from superstore.

-- 6. Find customers whose name matches '%john%' case-insensitively with ILIKE.

-- 7. Use ANY with an array to return rows where region is either Central or South.