Run a query that returns the number of trouble tickets in the
VTM024… table, but only the ones created in the year 2015. Note: when
setting the where criteria, use a function to extract the Year portion
from the timestamp field.
Using the Year function in the first answer, write SQL that shows
the number of trouble tickets created in each year dynamically, and do
this using a “GROUP BY” clause in the SQL. It should return something
I found the answer to first query. Can someone help me with 2nd one?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: