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: SELECT and FROM

Solution: SELECT and FROM - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: SELECT and FROM

“

- [Instructor] Next, we'll walk through the solution to the assignment. As a recap, Uncle Jimmy wants the first name, last name, and email of each of the customers in your database. Anytime we need to write a query, the first thing we're going to do is open up Workbench. In this case, I know we need to find data around our customers, their first name, their last name, and their email. So, I'm going to go into the Schemas tab and I'm going to look through the tables and try to get a sense by reading the table names which tables I might need to use for this. So, I'm interested to see if there's a table that's called customers or emails or something like that that could lead me on the right track. And so I see this customer table and I see, nope, I don't see anything that says emails. So, I'm going to start with customer and see what we have in there. So, when you click into the triangle here next to the table, you'll see which columns are in there. And I'm going to go ahead and open…

Contents