Task: Create a natural language question embodying the following SQL statement:
ID: 3886321 • Letter: T
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