I hereby claim:
- I am stellamiranda on github.
- I am stella (https://keybase.io/stella) on keybase.
- I have a public key ASCIeBQHG94CqMDle_YK1Yu782m2H6hXUP60iWsorLv7awo
To claim this, I am signing this object:
# Challenge: Staircase - HakerRank | |
# Author: Stella Miranda | |
# Consider a staircase of size n = 4: | |
# | |
## | |
### | |
#### |
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. | |
+----+------------------+ | |
| Id | Email | | |
+----+------------------+ | |
| 1 | john@example.com | | |
| 2 | bob@example.com | | |
| 3 | john@example.com | | |
+----+------------------+ | |
Id is the primary key column for this table. |
#Write a method kth_to_last_node() that takes an integer kk and the head_node of a singly-linked list, and returns the kkth to last node in the list. | |
def kth_to_last_node(k, head) | |
if k < 1 | |
raise ArgumentError, "Impossible to find less than first to last node: #{k}" | |
end | |
# STEP 1: get the length of the list | |
# start at 1, not 0 |
{ | |
"Abkhazia": { | |
"cn_name": "", | |
"flag": "https://upload.wikimedia.org/wikipedia/commons/2/27/Flag_of_Abkhazia.svg", | |
"flag_thumb": "https://upload.wikimedia.org/wikipedia/commons/thumb/2/27/Flag_of_Abkhazia.svg/200px-Flag_of_Abkhazia.svg.png" | |
}, | |
"Afghanistan": { | |
"cn_name": "", | |
"flag": "https://upload.wikimedia.org/wikipedia/commons/9/9a/Flag_of_Afghanistan.svg", | |
"flag_thumb": "https://upload.wikimedia.org/wikipedia/commons/thumb/9/9a/Flag_of_Afghanistan.svg/150px-Flag_of_Afghanistan.svg.png" |
Food: | |
Twice at day. | |
Obi doesn't eat much some times, that is normal, ideally will eat 1/2 cup of food on the morning, half on the afternoon. But being realistic, he eats less that it, unless he has been at the office running all day. | |
Pee: | |
2 or 3 times at day, depending on activity and water drink. If he stays at home, he could be just doing it at morning and evening. If going to the office, he can drink more water based on more activity and needs to be taken out just for pee after lunch. | |
Poo: |
gem install mysql2 -v '0.5.2' -- --with-mysql-config=/usr/local/bin/mysql_config --srcdir=/usr/local/include/mysql/ --platform=ruby --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include |
I hereby claim:
To claim this, I am signing this object:
env: | |
RUBY_VERSION: 2.7.1 | |
name: Rails tests | |
on: [push,pull_request] | |
jobs: | |
rspec-test: | |
name: RSpec | |
runs-on: ubuntu-18.04 | |
steps: |