{"id":210,"date":"2024-02-02T11:19:24","date_gmt":"2024-02-02T16:19:24","guid":{"rendered":"https:\/\/sites.temple.edu\/souravdas\/?p=210"},"modified":"2024-02-02T12:07:00","modified_gmt":"2024-02-02T17:07:00","slug":"lab-3-few-hints","status":"publish","type":"post","link":"https:\/\/sites.temple.edu\/souravdas\/2024\/02\/02\/lab-3-few-hints\/","title":{"rendered":"Lab 3: Few Hints"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"974\" height=\"181\" src=\"https:\/\/sites.temple.edu\/souravdas\/files\/2024\/02\/image-2.png\" alt=\"\" class=\"wp-image-215\" style=\"width:726px;height:auto\" srcset=\"https:\/\/sites.temple.edu\/souravdas\/files\/2024\/02\/image-2.png 974w, https:\/\/sites.temple.edu\/souravdas\/files\/2024\/02\/image-2-300x56.png 300w, https:\/\/sites.temple.edu\/souravdas\/files\/2024\/02\/image-2-768x143.png 768w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Report the employee_id, the name of the employee, and all his job assignments from table HR_Job_History. Report the start date and job id of each of the employee\u2019s jobs. Write the query in a total of 3 ways:<\/strong><\/li>\n<\/ol>\n\n\n\n<p><strong>A. Using equijoins (the older syntax)<\/strong><\/p>\n\n\n\n<p>hr_employees w, hr_job_history l<\/p>\n\n\n\n<p>where &#8230;.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>2. <strong>Change the query of question 1 to be able to see ALL the employees, including those without previous job assignments. If an employee has no job assignments, then print &#8217;01\/01\/1900&#8242; and \u2018-99\u2019.<\/strong><\/p>\n\n\n\n<p>Use LEFT OUTER JOIN<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A. Using equijoins (the older syntax) hr_employees w, hr_job_history l where &#8230;. 2. Change the query of question 1 to be able to see ALL&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/sites.temple.edu\/souravdas\/2024\/02\/02\/lab-3-few-hints\/\">Continue reading<span class=\"screen-reader-text\">Lab 3: Few Hints<\/span><\/a><\/div>\n","protected":false},"author":35813,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/users\/35813"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":7,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":230,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/210\/revisions\/230"}],"wp:attachment":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}