100分求3个SQL语句

Question

1.
select LastName,FirstName,PhoneNumber,'Customer'
from Customers
union
select LastName,FirstName,WorkPhone,'SalesPerson'
from SalesPersons2.
select a.LastName,a.FirstName,b.LastName,b.FirstName
from Customers a,SalesPersons b,Orders c
where a.CustomerID=c.CustomerID and b.SalesPersonID=c.SalesPersonID3.
select *,
convert(varchar(8),(Unitprice-(select avg(Unitprice) from Products))*100/Unitprice)+'%' 
from Products
where Unitprice>(select avg(Unitprice) from Products)

Answer 1

1.
select LastName,FirstName,PhoneNumber,'Customer'
from Customers
union
select LastName,FirstName,WorkPhone,'SalesPerson'
from SalesPersons2.
select a.LastName,a.FirstName,b.LastName,b.FirstName
from Customers a,SalesPersons b,Orders c
where a.CustomerID=c.CustomerID and b.SalesPersonID=c.SalesPersonID
3.
select *,
convert(varchar(8),(Unitprice-(select avg(Unitprice) from Products))*100/Unitprice)+'%' 
from Products
where Unitprice>(select avg(Unitprice) from Products)教科书写法~
很标准

Answer 2

结贴了，谢谢lw1a2(一刀），^_^