{"id":196,"date":"2024-01-25T22:04:16","date_gmt":"2024-01-26T03:04:16","guid":{"rendered":"https:\/\/sites.temple.edu\/souravdas\/?p=196"},"modified":"2024-02-02T12:02:46","modified_gmt":"2024-02-02T17:02:46","slug":"lab-2-few-hints","status":"publish","type":"post","link":"https:\/\/sites.temple.edu\/souravdas\/2024\/01\/25\/lab-2-few-hints\/","title":{"rendered":"Lab 2: Few Hints"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li><strong>Write a query to list the employees first, and last name as well as their hire date and commission_pct. If the commission_pct is empty report 0 instead. Order by Last name alphabetically in ascending order.<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>NVL(commission_pct, 0) <\/em><\/p>\n\n\n\n<p><strong>3. Find the average salary of employees<\/strong><\/p>\n\n\n\n<p><em>Use avg(salary)<\/em><\/p>\n\n\n\n<p>5. Count all the departments and also count all the departments without a manager.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"480\" height=\"342\" src=\"https:\/\/sites.temple.edu\/souravdas\/files\/2024\/01\/count.gif\" alt=\"This animation shows how count works.\" class=\"wp-image-201\" \/><\/figure>\n\n\n\n<p><em>Use count(*)<\/em><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>NVL(commission_pct, 0) 3. Find the average salary of employees Use avg(salary) 5. Count all the departments and also count all the departments without a manager.&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/sites.temple.edu\/souravdas\/2024\/01\/25\/lab-2-few-hints\/\">Continue reading<span class=\"screen-reader-text\">Lab 2: 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":[2],"tags":[],"class_list":["post-196","post","type-post","status-publish","format-standard","hentry","category-labs","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/196","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=196"}],"version-history":[{"count":8,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"predecessor-version":[{"id":229,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/posts\/196\/revisions\/229"}],"wp:attachment":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}