Putting it together

The Intermediate SQL Tutorial

Welcome to the Intermediate SQL Tutorial!

In the previous tutorial, many of the practice problems could only be solved in one or two ways with the skills you learned. As you progress and problems get harder, there will be many ways of producing the correct results. Keep in mind that the answers to practice problems should be used as a reference, but are by no means the only ways of answering the questions.

The Apple stock prices dataset

For the first few lessons, you'll be working with Apple stock price data. The data was pulled from Google Finance in January 2014. There's one row for each day (indicated in the date field). open and close are the opening and closing prices of the stock on that day. high and low are the high and low prices for that day. volume is the number of shares traded on that day. Some data has been intentionally removed for the sake of this lesson. Check it out for yourself:

SELECT * FROM 
  tutorial.aapl_historical_stock_price