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: WHERE and AND

Solution: WHERE and AND - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: WHERE and AND

“

- [Instructor] All right, here's the solution video for the assignment on multiple logical conditions using where and and. As a reminder, Uncle Jimmy wants payment data for your first 100 customers that's over $5 and has happened since January 1st, 2006. Let's go ahead and get into that. So since this is building off of a previous question, we've already got this query here. I'm going to go ahead and run it so that we can get familiar with the result. As we see here, we're pulling all records for the first 100 customers, customers with a customer ID that is under 101, regardless of when it happened or the amount. Uncle Jimmy would like us to add a couple of additional criteria to filter by. So we'll do that here. We've added filtering criteria for amount is greater than five, and payment date is after January 1st, 2006. Going to go ahead and run that and what we see here is a very, very limited result set. Only four records matching these criteria. Again, hopefully this is a good…

Contents