Using TinyCollege database, write the sql queries to answer each of the following questions. Your answer should
Fantastic news! We've Found the answer you've been seeking!
Question:
Using TinyCollege database, write the sql queries to answer each of the following questions. Your answer should consist of the SQL query and also the result of the query in a table form.
- Show all student number first name, last name, hire date all concatenated in one column.
- Show the student date of birth (stu_dob), the birth year, month and day in separate columns.
- Show the students attributes, and the dob according to format code 102. Format code 102 show the date as follows yyyy.mm.dd
- Show all students born between 1970 and 1975. Use the between operator. Show their first and last name in capital letters.
- Show the first 3 characters of the course description.
- Show the students that do not have initials.
- shows student num, last and first name, the birth year and their age. Age is calculated based on the difference between today's date (use getdate() function) and stu_dob. Use datediff() function to calculate the differencehttps://www.w3schools.com/sql/func_sqlserver_datediff.asp.
*DATABASE TO BE USED IN PICTURE BELOW*
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: