Starburst logo
Starburst logo

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 to increase your chances at the 30K prize! Each week will have it’s own Technical Achievement Challenge. You must be considered a valid entry to win 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.

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 may be querying 7 different tables.  View the ER diagram.

  • tpch.tiny.customer
  • tpch.tiny.lineitem
  • tpch.tiny.nation
  • tpch.tiny.part
  • tpch.tiny.orders
  • tpch.tiny.supplier
  • tpch.tiny.partsupp

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 may be querying 7 different tables. View the ER diagram.

  • tpch.tiny.customer
  • tpch.tiny.lineitem
  • tpch.tiny.nation
  • tpch.tiny.part
  • tpch.tiny.orders
  • tpch.tiny.supplier
  • tpch.tiny.partsupp

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