From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Solution: The WHERE clause

Solution: The WHERE clause - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: The WHERE clause

“

- [Instructor] Alright, here's the solution for the where clause assignment. As a refresher, Uncle Jimmy is looking for all payment data for your first 100 customers. Let's jump over to Workbench and get into it. Alright, the first thing we'll do is try to figure out what table to use. So we know we're looking for payment data about specific customers. So we might be using customer, you might be using payments. It's probably going to be in one of those two tables. So I'm going to take a look and see if I can find the right columns. So we have customer ID in here, but I don't see anything about payments. So we're going to go ahead and we're going to take a look at this payment-level table. And in here we have payment ID, we have customer ID and we've got amount. So, I think this is going to be our table, and this is what Jimmy's looking for. So, first thing we're going to do (keyboard keys clicking) is just get all the data out of payment. Yep, so this looks like what we're looking…

Contents