From the course: Database Foundations: Intro to Databases

Unlock the full course today

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

Solution: Write a SQL SELECT query

Solution: Write a SQL SELECT query

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial Buy for my team

Solution: Write a SQL SELECT query

“

(bouncy upbeat music) - [Instructor] In this code challenge, we were asked to find some chicken-based recipes that we can prepare quickly from a table of recipes we've got stored. And I'm just going to run the SELECT statement just so we can see the data that we have to work with. So we have a total of 25 different recipes here. I've got spaghetti carbonara, chicken tikka masala. If I scroll over here to the right, I've got a column for the primary ingredient. So this is an identification number for the ingredient, as well as the prep time and the date that this recipe was added into our table. So that is the recipes table. We can also take a look at the ingredients table by changing the SELECT statement to SELECT * FROM Cooking.Ingredients. And here we can see the ID numbers for each of our ingredients, as well as the name. So here is the one that we're interested for this challenge, chicken, which is ingredient ID number two. All right, with all of that in mind, we can get started…

Contents