Need help for SQL , Track Trackid Name Album -MediaType e- 3 AlbumId Artistid Na

Question

Need help for SQL

, Track Trackid Name Album -MediaType e- 3 AlbumId Artistid Name MediaTypeld Name Tite Artistld MediaTypeld Genreld Composer Milliseconds Genre Genreld Name PlaylistTrack Playlistld Trackld Playlist Playlistid Name oBytes UnitPrice InvoiceLine InvoiceLineld Invoiceld Trackld UnitPrice Quantity Employee Employeeld LastName FirstName Tite ReportsTo BirthDate HireDate Address Customer Customerld FirstName LastName Invoice Invoiceld CustomerId InvoiceDate BillingAddress BillingCity BillingState BillingCountry illingPostalCode Total Company Address State Country PostalCode Phone State Country PostalCode Phone Fax SupportRepld

Explanation / Answer

Query:

Select Emp1.FirstName,Emp1.LastName,Emp1.Title, Emp2.FirstName as SuperFirst,Emp2.LastName as SuperLast ,Emp2.Title as SuperTitle from Employee Emp1 inner join Employee Emp2 on Emp1.ReportsTo = Emp2.EmployeeId order by Emp1.Firstname,Emp1.LastName,Emp1.Title,Emp2.FirstName, Emp2.LastName, Emp2.Title ;

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.