SQL Exercise – How to Swap Columns? (MySQL)
Let’s suppose we have a table containing two columns ID and sex, and our task is to swap the values of sex i.e. from ‘f’ to ‘m’ and from …
Steem API – Get Curation Stats
How much can you earn by upvoting steemit posts (curation) per day? You can see curation rewards for the last 7 days via (Rewards -> Curation Rewards) I spent …
SteemSQL Tutorial – Finding Inactive Steemians that You Follow
If you have a following list that you would like to unfollow if he/she is inactive for at least 7 days, you might run the following SQL query (thanks …
[Answer] Mathematics × Programming Competition #8 – Four Digit Calculator
![[Answer] Mathematics × Programming Competition #8 – Four Digit Calculator](https://helloacm.com/wp-content/uploads/2017/10/0159-300x200.png "[Answer] Mathematics × Programming Competition #8 – Four Digit Calculator")
Given a four digit calculator, if you rotate it by 180 degree, you may get another ‘valid’ number. For example, 0159 becomes 6510 if rotated 180 degree. The ‘1’ …
The Simple Risk Register for Project Management
The Risk Register is a simple method to record the potential risks during a project. The risks need to be assessed from time to time so that potentially they …
SteemSQL Tutorial – Count Total Interests Sent
@justyy ‘s CN Bank has been running exactly a month now and it is giving out daily interests as SBD. I wonder how much interests I have sent out …