Question
Using the same table as Exercise 9, write a query that retrieves the TerritoryID and BusinessEntityID that have a start date of May 31, 2011
Using the same table as Exercise 9, write a query that retrieves the TerritoryID and BusinessEntityID that have a start date of May 31, 2011 and end date of Nov. 29, 2012. Also, create a new column named age and calculate the days between the start date and end date.
SQL Chart
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Big Data Fundamentals Concepts, Drivers & Techniques
Authors: Thomas Erl, Wajid Khattak, Paul Buhler
1st Edition
0134291204, 9780134291208
