Please help write the problems below in SQL using the relationships and tables b

Question

Please help write the problems below in SQL using the relationships and tables below:

Projects V ProjectID ProjectName ProjectAssignments EmployeeID ojectID Customers customerID -1 firstname ast name Street1 Street2 City Employees EmployeeID Firstname Lastname Department JobClass SupervisorID Start Date EndDate Pay Rate Pay Type Pay Account Hours PostedThisWeek AccruedSickLeave Taken SickLeave Orders order Number CustomerID OrderDateTime PaymentType Amount Departments Department Accounts V Account Number Title ContractNumbe Begin Date Sales Contacts Contact ID Firstname Last name Street1 Street2 City State Zip

Explanation / Answer

I can only found these query from your question.

7. CREATE VIEW mailing_label AS SELECT distinct(CONCAT_WS(" ", `C.firstname`, `C.lastname`)) NAME,distinct(CONCAT_WS(" ", `S.Street1`, `S.Street2`, `S.City`, `S.State`, `S.Zip`)) ADDRESS, FROM Customers C Join SalesContacts S on C.firstname = S.Firstname and C.lastname = S.LastName ;

8.Select * from Employees;

9. I am not able to find the salary column.

10 & 11 is nothing about the query in sql but asking to create a form which is undefine for me.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---