SQL practice: Views

Create a view customer_summary with customer_name, total_orders, total_spent.

Query it for customers who spent over 50000.

Query it for customers who have never ordered.

Create a view product_performance with product name, units sold and revenue.

Use that view to find the top 5 products by revenue.

Create a view showing employees without their salary column.

Drop the view from 30-6. (Look up DROP VIEW.)

Explain why customer_summary needs LEFT JOIN rather than JOIN.