Advertisement
StoyanGrigorov

Untitled

Feb 14th, 2017
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.38 KB | None | 0 0
  1. SELECT DISTINCT * FROM
  2. (
  3.     SELECT
  4.             c.CustomerID,
  5.             CONCAT(c.FirstName, ' ', c.LastName) AS [FullName],
  6.             DATEDIFF(YEAR, c.DateOfBirth, '20160101') AS [Age]
  7.     FROM Customers AS c
  8.     INNER JOIN Tickets AS t
  9.     ON t.CustomerID = c.CustomerID
  10.     INNER JOIN Flights AS f
  11.     ON f.FlightID = t.FlightID
  12.     WHERE f.Status = 'Arrived'
  13. ) s
  14. WHERE s.Age < 21
  15. ORDER BY s.Age DESC, s.CustomerID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement