Testing Github Issue Posting

[wbfrench1]

When a user posts to Github do other members of the group receive notifications?

[VintageGold]

I did receive this notification in an email. Where did you receive this comment?

[xinxueHEAI]

@tkelly9 @VintageGold @wbfrench1 @Colsai let me know if "this comment" triggered email notifications?

[wbfrench1]

I got it!

Cheers@! Barker

On Sat, Oct 2, 2021 at 2:01 AM xinxueHEAI @.***> wrote:

@tkelly9 https://github.com/tkelly9 @VintageGold https://github.com/VintageGold @wbfrench1 https://github.com/wbfrench1 @Colsai https://github.com/Colsai let me know if "this comment" triggered email notifications?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/VintageGold/Data690_MathML/issues/1#issuecomment-932689509, or unsubscribe https://github.com/notifications/unsubscribe-auth/APA2ZQY7HAGQSDXSFEWPYHTUE2N2HANCNFSM5FDMIODA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[wbfrench1]

Hey Adam/Xin! Is there a way to allow classmates to post files to this page? Pratik and Srashti were unable to upload files to the page. This was important because for our group work we wanted to include screen shots, which we think requires uploading files.

[pmathur2]

M4ML_SQL_Group_Assignment_pmathur2.docx

Hello, can everyone see the attachment?

[xinxueHEAI]

@wbfrench @pmathur2 Thanks for the attachment. Yes, I am able to download it.

Please try use MarkDown format. For example, code # SQL SELECT * FROM table1 AS t1;

Hyperlinks: this page

You can also drag screenshots directly to the text-box here.

Could you post your results like this to the issue page? Thanks.

[xinxueHEAI]

like this

[pmathur2]

OVER is used to create or define a window of rows. A window of rows is a set of rows that is derived from the underlying query result and computes a scalar result value.

PARTITION BY is a window partition subclause that restricts the size of the window that a window function operates on. In the absence of a PARTITION BY subclause, OVER will act on the entire query. NO Partition Clause – note grand total is all rows

Partition by custid – the sum function now acts on the window defined by partition, which is the custid. Instead of summing up the val column over all customers, the sum function now acts over each customer individually, providing the total value of each customer's orders on each orderid row.

ORDER BY is also a window partition subclause that defines the order that the window function operates on the val column as well as the effect the sum function has on the val column. Notice below how the output of the sum function changed from a sum of all of the orders by customer to a running total of each customer's orders ordered by order date.

Pratik: To answer the question “when should I be using OVER(PARTITION BY field1 ORDER BY field2)” given the above example, you should PARTITION by field1 when you want to apply a function on a group-by-group basis using field1 (i.e. customer IDs). The ORDER BY field2 can be added for readability if you want to sort the your output by a certain field 2 (i.e. in the first partition of customer ID=1, sort them by order date, then for the 2nd partition of customer ID=2, sort them by date as well, etc..). This enhances the overall readability for the data scientist.

[pmathur2]

When I attempt to push the Calculator.ipynb to the github repo I get the following error:

Just before pushing, it asks me for my token, which I copy/paste in. However, it appears like I am getting a permission denied to push to the main branch. Do you know why?

[VintageGold]

Hi,

Thank you for reaching out :). Try pushing again, I am not sure if your invitation to join the repo expired. But I just added you again as a collaborator.

Thank you, Adam Goldstein

On Sun, Oct 17, 2021 at 10:59 PM pmathur2 @.***> wrote:

When I attempt to push the Calculator.ipynb to the github repo I get the following error: [image: image] https://user-images.githubusercontent.com/78404112/137662466-ad6c864f-962b-4c3b-88fc-608770e06009.png

Just before pushing, it asks me for my token, which I copy/paste in. However, it appears like I am getting a permission denied to push to the main branch. Do you know why?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/VintageGold/Data690_MathML/issues/1#issuecomment-945320146, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMOKWEKVNOLRV3RPWVFE2STUHOERJANCNFSM5FDMIODA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[pmathur2]

I think it worked this time. Do you see an updated Calculator.ipynb file containing the sqrtnm() method?

[VintageGold]

Yes, I see it!

On Mon, Oct 18, 2021 at 2:27 PM pmathur2 @.***> wrote:

I think it worked this time. Do you see an updated Calculator.ipynb file containing the sqrtnm() method?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/VintageGold/Data690_MathML/issues/1#issuecomment-946046145, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMOKWEJMLBD7BXNYGMY3GRLUHRRH3ANCNFSM5FDMIODA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.