From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Query data

Solution: Query data

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial

Solution: Query data

“

(upbeat music) - [Instructor] I hope you were able to answer the three questions for the challenge and let's walk through the answers together. I'm going to select anything inside of the Two Trees database, just to make sure that I get a good query window that's attached to the right database. So I'll press Control + N to open up a new query window. All right, let me type out some notes here just so I can remember what it is that we're trying to do. So question one was to convert size from ounces to milliliters. Question two is to find out how many products are in each size and question three was to find the highest priced product in the cosmetic product line. All right. So let's go ahead and get started with question one. I'm just going to move these down on the screen a little bit. So the first thing we need to do is take a quick look through our data tables and we open up a products table and take a look at…

Contents