From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solution: Create a view
From the course: Database Foundations: Database Management
Solution: Create a view
(upbeat music) - [Instructor] I hope you were able to add in the two requested views for the two trees database. Let's walk through the solution together. I'm going to continue working on the two trees database. That's in my PostgreSQL server, since that's the one I've been working on and making changes to. So let's go ahead and right click on that and choose new query and get started here. I'm goona make a couple of notes at the top just so I can remember what it is that we're trying to do. And so the first part of the challenge asked to aggregate the number of orders placed by each company. Just going to create that as a little note here at the top there. And then the second part of the challenge asked to multiply the quantity times the price for each of the order lines. So that is the two things that we're trying to do. So let's go ahead and get started with this first one. We're going to aggregate the number of orders placed for each company. So let's take a look at the orders…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.