StationX
Start free

Browse › MySQL Database Query

Combining Data with UNIONS

Guided

Part of MySQL Database Query Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge you will write several MySQL queries to combine data by using the UNION set operator.

  1. Develop a query that combines data from two result sets
  2. Develop more specific queries that will combine result sets by removing and retaining duplicates
  3. Explore queries that will sort the combined result sets

Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

  • ⏱ About 30 minutes