From the course: Database Foundations: Intro to Databases

Unlock the full course today

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

Challenge: Query data

Challenge: Query data

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial

Challenge: Query data

“

(upbeat music) - [Instructor] Before we call this course complete, I'd like you to try your hand at writing a few queries. For your last challenge try and find the answers to the following questions using the data in the Two Trees database. Question one, product sizes are stored in us fluid ounces. What are the equivalent sizes in milliliters? The conversion formula that you'll need to know is that one ounce is equal to 29.57353 milliliters. Question two, how many different product skews are available in each size? And question three, what is the highest priced cosmetic product? I estimate that these questions should take 15 minutes, or less to answer. My advice is to start slow. Build your queries one component at a time and test them frequently as you go along. I'll show you how I'd approach these questions in the next movie. Good luck.

Contents