Question
Create a list of student ID, first and last names, and the number of years since they registered (show only 2 decimal places Hint use
Create a list of student ID, first and last names, and the number of years since they registered (show only 2 decimal places Hint use the To_Char function to show the decimal places) for those students who live in an zip that begins with 84 and ends in 4. Sort the list on the number of years from lowest to highest then last name and first name. Note that your years may not exactly match my numbers depending on when you ran your query compared to when I ran mine. Hint: use Months_Between function to calculate Years and the SysDate function to get today's date.
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