Technical Achievement Challenges

Mission 3

Back by popular demand, our Technical Achievement Challenges are returning in Mission 3! Answer our SQL based questions each week, and win an e-gift card AND increase your chances at the 30K prize! This time we have created three Technical Achievement Challenge Sprints. Each sprint lasts one week and contains two SQL questions that build upon one another. You must be considered a valid entry to win the e-gift card which includes, but is not limited to, registering with a valid LinkedIn and qualifying as a data professional. For more information visit the sweepstakes rules.

Sprint 1: 7/19-7/22

Sprint 2: 7/26-7/29

Sprint 3: 8/2-8/5

Challenges will close at 5pm EST each Friday!

As usual, these challenges can be completed using Starburst Galaxy or Trino, the choice is yours. All the details you need to complete these SQL based problems are available by following this easy guide.

Starburst Galaxy

  1. Sign up for Starburst Galaxy!
  2. Log in to Starburst Galaxy 
  3. Navigate to the Clusters pane
  4. Start the Cluster named “Sample” 
  5. Navigate back to the Query Editor
  6. Select the catalog “tpch”
  7. Select the schema “tiny”

You will be querying 5 different tables.

  • tpch.tiny.customer
  • tpch.tiny.supplier
  • tpch.tiny.nation
  • tpch.tiny.region
  • tpch.tiny.orders

Watch as I walk you through how to query the datasets using Starburst Galaxy.

 

Trino

  1. Clone the GitHub repository
  2. Follow the Mission 3 Step-by-Step guide to log into the mysql trino coordinator node
  3.  Use the Trino CLI query the “tcph” catalog and “tiny” schema

You will be querying 5 different tables.

  • tpch.tiny.customer
  • tpch.tiny.supplier
  • tpch.tiny.nation
  • tpch.tiny.region
  • tpch.tiny.orders

Watch as I walk you through the steps for querying both tables below using Trino.

 

Start Free with
Starburst Galaxy

Up to $500 in usage credits included

  • Query your data lake fast with Starburst's best-in-class MPP SQL query engine
  • Get up and running in less than 5 minutes
  • Easily deploy clusters in AWS, Azure and Google Cloud
For more deployment options:
Download Starburst Enterprise

Please fill in all required fields and ensure you are using a valid email address.