{"id":210432,"date":"2018-09-14T12:46:37","date_gmt":"2018-09-14T12:46:37","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/14\/ecet-450-week-4-practice-exercises\/"},"modified":"2018-10-24T08:47:54","modified_gmt":"2018-10-24T08:47:54","slug":"ecet-450-week-4-practice-exercises","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/ecet-450-week-4-practice-exercises\/","title":{"rendered":"ECET 450 Week 4 Practice Exercises"},"content":{"rendered":"<p>FOR QUESTIONS 1-10:\u00a0Given the following table named\u00a0DEPT,\t\u00a0\tDEPTNO \ufffd\u00a0\u00a0\u00a0\u00a0 DNAME \ufffd \ufffd\u00a0 LOC\t10\t20\t30\t40 \ufffd\u00a0\u00a0 ACCOUNTING\tRESEARCH\tSALES\tOPERATIONS NEW YORK\tDALLAS\tCHICAGO\tBOSTON\t\u00a0\tWrite an SQL script for the following returned data:<\/p>\n","protected":false},"excerpt":{"rendered":"<p>FOR QUESTIONS 1-10:\u00a0Given the following table named\u00a0DEPT, \u00a0 DEPTNO \ufffd\u00a0\u00a0\u00a0\u00a0 DNAME \ufffd \ufffd\u00a0 LOC 10 20 30 40 \ufffd\u00a0\u00a0 ACCOUNTING RESEARCH SALES OPERATIONS NEW YORK DALLAS CHICAGO BOSTON \u00a0 Write an SQL script for the following returned data:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-210432","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/210432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=210432"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/210432\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=210432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=210432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=210432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}