From the course: Introduction to Amazon Redshift: Data Management Essentials

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Using CoderPad for this code challenge

Using CoderPad for this code challenge - Amazon Web Services (AWS) Tutorial

From the course: Introduction to Amazon Redshift: Data Management Essentials

Start my 1-month free trial Buy for my team

Using CoderPad for this code challenge

“

(lively techno music) - [Instructor] For this challenge, you're going to explore the schema of the sample data and write your own SQL query. Let's go back to the query we ran before in our query editor. It says, select top 100 star from sample_data_dev.ticket.sales. Looking through these 100 records returned from this query, let's say you wanna find out who one of these people are. So as a hint and a quick refresher on your SQL skills, you'll want to use a where clause to limit the data down to just what you need. So at the end of the query, you'll put a where, field name, equals, and then the ID of the buyer. But you'll need to figure out which field name to use. So you'll need to explore the schema of the Redshift sample data. So write a query that gets only the first and last name of buyer ID 256. We will use a code challenge within the course that will help you get your query correct, and then you can copy and…

Contents