Task: Create a natural language question embodying the following SQL statement:

Question

Task: Create a natural language question embodying the following SQL statement: SELECT IName, hState FROM Personnel WHERE PerlD = (SELECT PerlD FROM DocContributor WHERE DocID = (SELECT docID FROM Document WHERE docPub = "McGraw Hill")): Task: Fill a 4x6 grid with the column headers and the first five rows according to the following SQL statement: SELECT p.IName, p.hState, pm.leadPer, pr.start Date FROM Personnel p, Project Member pm, Project pr WHERE p.PerlD = pm.PerlD AND pm.ProjlD = pr.ProjID AND pm.leadPer = "Yes'' ORDER BY pr. start Date: Task: Fill a 3x4 grid with the column headers and first three rows according to the following SQL statement: SELECT d.DocID, d docPub, p start Date, FROM Document d LEFT JOIN Project p WHERE d DocID = p.rep Result ORDER BY d DocID DESC: Task: Create a natural language question embodying the following SQL statement: SELECT p.IName, p.fName, p.hState, pm.PerlD, pm.leadPer FROM Personnel p RIGHT OUTER JOIN Project Member pm ON p.PerlD = pm.PerlD ORDER BY pm.ProjlD DESC, pm.PerlD;

Explanation / Answer

1.

Find the list of users with initial name and state who has contributed documents for McGraw Hill

2.

IName, hState, leadPer, startDate

Publ1, NYC, yes, 2017-08-11

Pub2,DC,yes,2017-08-20

Pub3,Chicago,yes,2017-08-28

Pub4, miami,yes,2017-09-05

Pub5,vegas,yes,2017-09-11

Pub6,california,yes,2017-09-15

3.

Docid,docpub,startdate

1,xyz,2017-04-11

2,abc,2017-07-11

3,zns,2017-08-11

4.

Get the person details who is a project member with Initial Name, First name, state, personid, leadper

Order by projectid with decreasing order and order by person id

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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