SQL-Joins, Functions_rewritten.docx - Studentu2019s Name...

This preview shows page 1 - 2 out of 2 pages.

Student’s NameProfessor’s NameCourseDateSQL – Joins, FunctionsQ1. List all teachers. Show salutation in all lower instances, remaining call in all top instances and get in touch with number inside the layout of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function SUBSTR(telephone, 1,threetelephone, 4,three '-' smartphone, 7,four)FROM trainer;Q2. List all college students (display student_id, first name, closing name, avenue deal with, zipcode, city, and state) who live in New York, NY. Sort results via last call, after which first call, in descending order.SELECT student.Student_id, pupil.First_name, pupil.Last_name, scholar.Street_address, pupil.ZipFROM scholarINNER JOIN zipcode ON student.Zip = zipcode.ZipWHERE zipcode.State = 'NY'ORDER BY last_name DESC, first_name;Q3. Display the metropolis wherein every teacher lives. List first name, remaining call, zip, town, and state. Display "N/A" for zip, town, and kingdom if an instructor does no longer

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture