Page 1 of 1
--Q3 -- Find the First Name and Last name --All customers are listed in the Sales.Customers table --Person.peron table h
Posted: Fri May 20, 2022 4:55 pm
by answerhappygod
- Q3 Find The First Name And Last Name All Customers Are Listed In The Sales Customers Table Person Peron Table H 1 (74.04 KiB) Viewed 42 times
--Q3 -- Find the First Name and Last name --All customers are listed in the Sales.Customers table --Person.peron table has the names of everyone --for simplicity lets assume that Sales.Customers and Person person are related on customers.customerID = p.BusinessEntityID -- If a person is a customer select the customerID, if not levae it a blank --Q4 --Find the First Name and Last name of all persons who are not customers --All customers are listed in the Sales.Customers table --Person.peron table has the names of everyone --for simplicity lets assume that Sales.Customers and Person person are related on customers.customerID = p.Business EntityID --Q5 --Find the First Name and Last name of all persons who are not employees --All employees are listed in the Human Resources.Employees table --Person.peron table has the names of everyone --HumanResources. Employee and Person.person are related on BusinessEntityID