• Complete the following statements to list the project ID and project start date of all projects that were created for client ID 5 or 6.

  JOIN Projects Clients WHERE Projects.ClientID = Clients.ClientID GIVING Temp1 PROJECT Temp1 OVER (ProjectID, ProjectStartDate, ClientID) GIVING Temp2 SELECT Temp2 WHERE ClientID = 5 GIVING Temp3 PROJECT Temp3 OVER (ProjectID, ProjectStartDate) GIVING Temp4 SELECT Temp2 WHERE ClientID = 6 GIVING Temp5 PROJECT Temp5 OVER (ProjectID, ProjectStartDate) GIVING Temp6 _____ Temp5 WITH Temp6 GIVING Answer

  a. JOIN

  b. UNION

  c. OR

  d. INTERSECTION

Transcribed Image Text:

TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on Rails CODE04 Code SQL CODE05 Code HTML CODE06 Code CSS CODE07 Code JavaScript CODE08 Perform analytics CODE09 Select technology stack CODE 10 Apply SEO CODE12 Create prototype CODE13 Code WordPress CODE14 Code Python CODE15 Create shopping cart CODE16 Code Other DB01 DB02 DB03 DB04 DB05 MEETOO Design relational database Convert data Install MySQL database Install SQL Server database Install Access Database Initial customer meeting CategoryID Per Coding Hour Coding Hour Coding Hour Coding Hour Coding Hour Coding Hour Coding Hour Coding Hour Coding Hour Coding Coding Coding Coding Coding Coding Database Database Database Database Database Estimate $150.00 $150.00 $150.00 $150.00 $100.00 $100.00 $125.00 $100.00 $200.00 Hour $125.00 Hour $150.00 Hour $100.00 Hour $150.00 Hour $125.00 Hour $150.00 Project $1,000.00 Hour $125.00 $500.00 $500.00 $400.00 $0.00 Project Project Project Meeting Project