SQL Assignment Cannot use “INNER, LEFT, or RIGHT JOIN” and “ON” syntax to perfor

Question

SQL Assignment

Cannot use “INNER, LEFT, or RIGHT JOIN” and “ON” syntax to perform the join operation SQL Assignment

c. Asg1 : Database-DAClass1410Fall201 7Asg1.ac RELATIONSHIP TOOLS ; FILE HOME CREATE EXTERNAL DATA DATABASE TOOLS DESIGN Hide Table Direct Relationships XClear Layout Edit Relationship Report Relationships Close Table All Relationships Tools Relationships SECURITY WARNING Some active content has been disabled. Click for more details. Enable Content >> | Relationships Employee id tcode dcode ssn last name first name middle_init hire salary Title code name min salary max salar) Assignment eid pcode start end hoursper week Hours ooeid Department pcode monday hours worked code name fill_level salary budget Project code name dcode start end estimated hours Ready NUM LOCK

Explanation / Answer

1. Select name,start,end from Project;

2. Select * from Hours where hours_worked > 1;

3. Select * from Project order by estimated_hours desc,name asc;

4. Select * from Title Natural Join Employee;

5. Select Project.* from Department Natural Join Project where start = '01/05/2000';

6. Select * from Department Natural Join Employee Natural Join Assignment;

7. Select Title.* from Title Natural Join Employee where Employee.tcode != Title.code;

8.  Select Project.* from Project Natural Join Assignment where Project.code != Assignment.pcode;

9. Select count(*) from Project;

10. Select pcode,count(*) from Assignment group by pcode;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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