From the course: Introduction to Analytics Engineering
Schalten Sie den kompletten Kurs noch heute frei
Join today to access over 23,400 courses taught by industry experts.
Solution: Add a pull request
From the course: Introduction to Analytics Engineering
Solution: Add a pull request
(upbeat music) - [Instructor] Let's go over the solution. It doesn't need to be exact at all, but your model should look something similar. So we're going to go over making the PR together. Let's go in the second challenge folder of the GitHub repo. And we're going to use this file that says make-pr-here. This is just the solution from the first challenge, and you are of course welcome to use your own solution. Now let's add in the customers table and add in the total number of states. So we're going to hit edit here, and we're going to first put in the customers table. So we're going to join customers on the customer ID, which was labeled cust_id. And we're going to add in the count of states. Now this needs to be a distinct because we only want to count the state once per product. We're just trying to see where the product is going. Total_States. Great. Nice work adding in the changes. Now we're going to commit this as a…