Create a query all table records in person-person


Problem

a) Create a query all table records in Person.Person and display records with FirstName that starts with the letter K and FirstName ends with N.

b) Create a JOIN on the table Person.Person and Person.PersonPhone and Person.EmailAddress and display the columns BusinessEntityID, PhoneNumber, EmailAddress, ModifiedDate

c) Create a JOIN on the table Person.Person and Person.PersonPhone and display the columns FirstName, LastName, PhoneNumber.

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Create a query all table records in person-person
Reference No:- TGS03277133

Expected delivery within 24 Hours