StationX
Start free

Browse › T-SQL Database Query

Can You Aggregate Data from Multiple Tables in Transact-SQL?

Expert

Part of T-SQL 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 lab, you will write several Transact-SQL queries to summarize data from multiple tables.

  1. Launch Microsoft SQL Server Management Studio (SSMS)
  2. Write a query by using inner and outer joins
  3. Develop a query that uses the DATEDIFF and DATEADD functions for performing calculations on date and time data
  4. Develop a query that aggregates data by using the GROUP BY and HAVING clauses

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

  • ⏱ About 60 minutes