Hands-on task
This task is step 10 of the course “PostgreSQL: from your first database to transactions”
PostgreSQL: view (VIEW)
In the shop database, create a view customer_totals with columns name and total — the customer's order total (only customers who have orders).
Reference:psql
What you'll practise:
- view
- views
- join
- group by
- postgresql