{"id":203119,"date":"2018-09-13T23:20:19","date_gmt":"2018-09-13T23:20:19","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-345-week-1-ilab\/"},"modified":"2018-10-24T09:05:26","modified_gmt":"2018-10-24T09:05:26","slug":"bis-345-week-1-ilab","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-345-week-1-ilab\/","title":{"rendered":"BIS 345 Week 1 iLab"},"content":{"rendered":"<p>Student Name:\u00a0Name\tUsing Lab 1, answer the questions and provide copies of your SQL Statements and\/or results for each Section listed below\tPart A:\u00a0Customer List\u00a0(4 points)\ta.What does the ORDER BY clause do?\tb.Screen print your results and paste here:\tPart B:\u00a0Customer List with only customers In France or Germany\u00a0(4 points)\tPart C:\u00a0Using a Calculation in a Query\u00a0(5 points)\tPart D:\u00a0Products that are discontinued\u00a0(5 points)\tPart E:\u00a0Practice using the\u00a0BETWEEN\u00a0operator\u00a0(5 points)\tPart F:\u00a0Practice using the &#8220;IN&#8221;\ufffd operator\u00a0(5 points)\tPart G:\u00a0Understanding &#8220;NULL&#8221;\ufffd\u00a0(5 points)\tPart H:\u00a0Using a composite condition\u00a0(5 points)\tPart I:\u00a0Using a &#8220;DATE&#8221;\ufffd type variable and Concatenating Column Output\u00a0(5 points)\tPart J:\u00a0Using the &#8220;LIKE&#8221;\ufffd operator and the &#8220;%&#8221;\ufffd wildcard\u00a0(6 points)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Student Name:\u00a0Name Using Lab 1, answer the questions and provide copies of your SQL Statements and\/or results for each Section listed below Part A:\u00a0Customer List\u00a0(4 points) a.What does the ORDER BY clause do? b.Screen print your results and paste here: <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-345-week-1-ilab\/\" class=\"read-more\">Read More &#8230;<\/a><\/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-203119","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203119","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=203119"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203119\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}