From the course: Introduction to SQL Using Google BigQuery

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution: Financial analysis

Solution: Financial analysis - SQL Tutorial

From the course: Introduction to SQL Using Google BigQuery

Start my 1-month free trial Buy for my team

Solution: Financial analysis

“

(upbeat music) - [Instructor] All right, how was that challenge? Let's go through the solutions together, and I'll step you through exactly my thought process as I would answer these challenge questions. So let's start with question one, which top three product IDs are the best selling based off the total amount field? Now, these questions are going to be using a sales data set that we haven't really seen before in this course. So what we can do first is let's write our query to select from the sales. And as we're doing that, we can open up our BigQuery resource viewer. Now, having it side by side is maybe not such a bad idea for this instance, but we can potentially give ourselves more screen real estate by just clicking this little arrow here to toggle the panel explorer. Now we've got a little more comfy of a view. So when we look at question one, which top three product IDs are the best selling, we can look at this…

Contents