For queries 4-6, format them to look like queries 1-3. PROBLEM 2. [100 POINTS]Do

Question

For queries 4-6, format them to look like queries 1-3.

PROBLEM 2. [100 POINTS]Download the SPU Access database from Moodle. Rename it to YourLastName-SPJ accdb and implement each ofthe following queries saving them as QueulYouriasName.through QuaooVauraatName Make sure to close the database Then, upload to Moodle Drop Box. Query 1. SELECT FROM SPJ WHERE Query 2. SELECT SUM(QT) FROM SPJ WHERE Query 3. SELECT Sa, JJ FROM S, SPJ,J WHERE STATUS 20) AND SPJSa AND (SPJ JE J JE AND Query 4: P 495 P64 Select Quer R RE

Explanation / Answer

Screenshots are not clear. Although based on what i have understood here are the queries:

#4

Select P.P#, P.PName

From P, SPJ

Where (P.P# = SPJ.P#) AND (P.COLOR = 'RED') AND (SPJ.S# = 52)

#5

Select SPJ.S#, SPJ.P#,SPJ.J#,SPJ.Qty
From J, SPJ
Where (J.J# = SPJ.J#) AND (J.CITY = 'LONDON') AND (SPJ.QTY > 300)

#5

Select SPJ.S#,SPJ.J#,SPJ.Qty
From SPJ
Where P# = 'P3' AND SPJ.QTY > (Select AVG(QTY) From SPJ Where P# = 'P3')

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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