{"action":"created","issue":{"url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/7","repository_url":"https://api.github.com/repos/STID3014-A181/Main-Issues","labels_url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/7/comments","events_url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/7/events","html_url":"https://github.com/STID3014-A181/Main-Issues/issues/7","id":367520367,"node_id":"MDU6SXNzdWUzNjc1MjAzNjc=","number":7,"title":"Week05-1","user":{"login":"zhamri","id":24503750,"node_id":"MDQ6VXNlcjI0NTAzNzUw","avatar_url":"https://avatars3.githubusercontent.com/u/24503750?v=4","gravatar_id":"","url":"https://api.github.com/users/zhamri","html_url":"https://github.com/zhamri","followers_url":"https://api.github.com/users/zhamri/followers","following_url":"https://api.github.com/users/zhamri/following{/other_user}","gists_url":"https://api.github.com/users/zhamri/gists{/gist_id}","starred_url":"https://api.github.com/users/zhamri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhamri/subscriptions","organizations_url":"https://api.github.com/users/zhamri/orgs","repos_url":"https://api.github.com/users/zhamri/repos","events_url":"https://api.github.com/users/zhamri/events{/privacy}","received_events_url":"https://api.github.com/users/zhamri/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":26,"created_at":"2018-10-07T04:31:16Z","updated_at":"2018-10-07T06:13:26Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"## Instructions:\r\n\r\n1. Study the following SQL commands:\r\n    * [SQL UPDATE Statement](https://www.w3schools.com/sql/sql_update.asp)\r\n    * [SQL ORDER BY Keyword](https://www.w3schools.com/sql/sql_orderby.asp)\r\n1. Go to [Try-SQL Editor](https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_or).\r\n1. Choose table _Customers_.\r\n1. Then:\r\n    * Replace record No.3 with your information. \r\n    * Display all customers from Malaysia, Mexico and Brazil by descending order.\r\n\r\n## Submission\r\n1. All the related SQL commands.\r\n1. Screenshot the results. "},"comment":{"url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/comments/427628872","html_url":"https://github.com/STID3014-A181/Main-Issues/issues/7#issuecomment-427628872","issue_url":"https://api.github.com/repos/STID3014-A181/Main-Issues/issues/7","id":427628872,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzYyODg3Mg==","user":{"login":"chitramugil","id":43175057,"node_id":"MDQ6VXNlcjQzMTc1MDU3","avatar_url":"https://avatars2.githubusercontent.com/u/43175057?v=4","gravatar_id":"","url":"https://api.github.com/users/chitramugil","html_url":"https://github.com/chitramugil","followers_url":"https://api.github.com/users/chitramugil/followers","following_url":"https://api.github.com/users/chitramugil/following{/other_user}","gists_url":"https://api.github.com/users/chitramugil/gists{/gist_id}","starred_url":"https://api.github.com/users/chitramugil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chitramugil/subscriptions","organizations_url":"https://api.github.com/users/chitramugil/orgs","repos_url":"https://api.github.com/users/chitramugil/repos","events_url":"https://api.github.com/users/chitramugil/events{/privacy}","received_events_url":"https://api.github.com/users/chitramugil/received_events","type":"User","site_admin":false},"created_at":"2018-10-07T06:13:26Z","updated_at":"2018-10-07T06:13:26Z","author_association":"NONE","body":"TABLE:UPDATE\r\nUPDATE Customers\r\nSET ContactName='Chitramugil',City='Klang',Country='Malaysia',Address='Taman Ria 4',PostalCode='42200',CustomerName='Chitramugil Raman'\r\nWHERE CustomerID = 3;\r\n![1](https://user-images.githubusercontent.com/43175057/46578928-0e80bf80-ca3b-11e8-938a-89466a6ca557.PNG)\r\n\r\nTABLE 2:ORDER BY\r\nSELECT * FROM Customers\r\nWHERE Country IN ('Malaysia', 'Mexico', 'Brazil')\r\nORDER BY Country DESC\r\n![capture](https://user-images.githubusercontent.com/43175057/46578933-23f5e980-ca3b-11e8-95d0-98c6325d9c96.PNG)\r\n"}}
{"actor":{"display_login":"chitramugil"}}