Your First Challenge as a Data Analyst

Introduction

Welcome to your first challenge! This challenge is designed to help you apply your knowledge of SQL and solidify your understanding through hands-on practice. Completing these challenges is crucial for your success in SQL, so I strongly encourage you to participate actively. Throughout this course, we will provide various challenges that simulate real-world scenarios to make learning as practical and beneficial as possible.

Challenge Overview

Today marks your first day as a data analyst at Green Cycles, an online movie rental shop. You now have access to the company's database, and your first task has arrived.

The marketing manager has requested a list of all customers who have rented movies from the shop. Specifically, they need a report containing the following details for each customer:

• First Name
• Last Name
• Email Address

Your job is to write an SQL query to retrieve this data accurately from the database.

Steps to Complete the Challenge

1. Identify the Correct Table:

   • Look through the database schema to find the table that stores customer information.
   • Check the structure of the table to confirm which columns contain the required data.

2. Write the SQL Query:

   • Use the SELECT statement to retrieve the first_name, last_name, and email columns.
   • Ensure the query fetches data from the correct table.

3. Execute the Query:

   • Run the query in pgAdmin (or your preferred SQL tool).
   • Verify that the results match the requested details.

Your Task

Now, go ahead and write your SQL query to generate the required customer list. If you face any difficulties, don’t worry! We will go through the solution together after you attempt the challenge.

Good luck, and enjoy solving your first real-world SQL task!