View for active products
SQL
Easy
0 views
Problem Description
Create view v_active_products that filters Products where is_active=1.
Output Format
View created
Sample Test Case
Input:
Products(is_active)
Official Solution
CREATE VIEW v_active_products AS SELECT product_id, name, price FROM Products WHERE is_active = 1;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!