who could help me about these sevens SQL problem?? they are using see tables and

Question

who could help me about these sevens SQL problem?? they are using see tables and relationship.
Thanks!!

Customer Belongs to Region Project Region ID Holds Customer Na Eon-Name 1 Phone Number Start Date End Date Actual Start Date Actual End Date Actual Cost Worklog Works in tomer ID 1 Week Ending Hours worked ProjectTask Employee 1 Employee ID Region ID Task Start Dete Middle Initial Task End Date First Name Date of Hi wrt a sau surement lo display Region Name, customer Name, and D or hepraects whose Artuw End Daten atm 12stamos

Explanation / Answer

SELECT Region_Name,Customer_Name,Project_ID from

Region,Customer,Project where Actual_End_Date=

"12/31/2009";

SELECT Last_Name from Employeee,Region,Assignment

where Region_Name="Bay Area" Task_ID="1906";

SELECT Last_Name,First_Name from Employee,ProjectTask

where Employee_ID > Task_ID= "1510"

SELECT Region_Name from Region Where Budget<> MAX

(Budget) from Project

SELECT AVERAGE(Budget) from Project where

Region_Name="Sacramento" from Region;

UPDATE SET Total_Amount =

'(@Total_Amount/100)*10+@Total_Amount' where

Region_Name= 'LosAngeles';

SELECT Project_ID,ProjectDescription,Task_ID from

Project,ProjectTask

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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