Skip to content

Instantly share code, notes, and snippets.

View nassredean's full-sized avatar

Nassredean Nasseri nassredean

17 followers · 18 following
View GitHub Profile
@nassredean
nassredean / keybase.md
Created March 17, 2021 04:31

Keybase proof

I hereby claim:

  • I am nassredean on github.
  • I am nassredean (https://keybase.io/nassredean) on keybase.
  • I have a public key ASDhzpzFVD_NZEn66_r8IuDo8j3wQEonZn2d9ZcAsQ9QRwo

To claim this, I am signing this object:

@nassredean
nassredean / window-blog-post-query-result8
Last active June 2, 2016 15:06
+------------+------+--------+----------+------------------+
| store_id | mm | yyyy | amount | entered_at_row |
|------------+------+--------+----------+------------------|
| 1 | 11 | 2015 | 30000.0 | 1 |
| 1 | 12 | 2015 | 40000.0 | 1 |
| 2 | 11 | 2015 | 19000.0 | 1 |
| 2 | 12 | 2015 | 11400.0 | 1 |
| 3 | 11 | 2015 | 14000.0 | 1 |
| 3 | 12 | 2015 | 21000.0 | 1 |
+------------+------+--------+----------+------------------+
@nassredean
nassredean / window-blog-post-query-result7
Last active June 2, 2016 14:45
+------------+------+--------+----------+-------------------+
| store_id | mm | yyyy | amount | entered_at_rank |
|------------+------+--------+----------+-------------------|
| 1 | 12 | 2015 | 40000.0 | 1 |
| 1 | 11 | 2015 | 30000.0 | 1 |
| 2 | 12 | 2015 | 11400.0 | 1 |
| 2 | 11 | 2015 | 19000.0 | 1 |
| 3 | 12 | 2015 | 21000.0 | 1 |
| 3 | 11 | 2015 | 14000.0 | 1 |
| 3 | 12 | 2015 | 21000.0 | 1 |
@nassredean
nassredean / window-blog-post-query-result5
Last active June 2, 2016 14:42
+------------+------+--------+----------+-------------------+
| store_id | mm | yyyy | amount | entered_at_rank |
|------------+------+--------+----------+-------------------|
| 1 | 11 | 2015 | 30000.0 | 1 |
| 1 | 11 | 2015 | 10000.0 | 2 |
| 1 | 12 | 2015 | 40000.0 | 1 |
| 1 | 12 | 2015 | 30000.0 | 2 |
| 2 | 11 | 2015 | 11000.0 | 2 |
| 2 | 12 | 2015 | 11400.0 | 1 |
| 2 | 12 | 2015 | 10000.0 | 2 |
@nassredean
nassredean / window-blog-post-query-result3
Last active June 1, 2016 21:59
+------------+----------+---------------+
| store_id | amount | amount_rank |
|------------+----------+---------------|
| 1 | 40000.0 | 1 |
| 1 | 30000.0 | 2 |
| 1 | 30000.0 | 2 |
| 1 | 10000.0 | 4 |
| 2 | 19000.0 | 1 |
| 2 | 11400.0 | 2 |
| 2 | 11000.0 | 3 |
@nassredean
nassredean / window-blog-post-query-result6
Last active June 1, 2016 22:02
+------------+------+--------+----------+-------------------+
| store_id | mm | yyyy | amount | entered_at_row |
|------------+------+--------+----------+-------------------|
| 1 | 11 | 2015 | 30000.0 | 1 |
| 1 | 11 | 2015 | 10000.0 | 2 |
| 2 | 11 | 2015 | 19000.0 | 1 |
| 2 | 11 | 2015 | 11000.0 | 2 |
| 3 | 11 | 2015 | 14000.0 | 1 |
| 3 | 11 | 2015 | 14000.0 | 2 |
| 1 | 12 | 2015 | 40000.0 | 1 |
@nassredean
nassredean / window-blog-post-query-result4
Last active June 1, 2016 21:59
+------------+------+--------+----------+
| store_id | mm | yyyy | amount |
|------------+------+--------+----------|
| 1 | 11 | 2015 | 10000.0 |
| 1 | 11 | 2015 | 30000.0 |
| 2 | 11 | 2015 | 11000.0 |
| 2 | 11 | 2015 | 19000.0 |
| 3 | 11 | 2015 | 14000.0 |
| 3 | 11 | 2015 | 14000.0 |
| 1 | 12 | 2015 | 30000.0 |
@nassredean
nassredean / window-blog-post-query-result2
Last active June 1, 2016 21:19
+------------+----------+
| store_id | sum |
|------------+----------|
| 1 | 110000.0 |
| 1 | 110000.0 |
| 1 | 110000.0 |
| 1 | 110000.0 |
| 2 | 51400.0 |
| 2 | 51400.0 |
| 2 | 51400.0 |
@nassredean
nassredean / window-blog-post-query-result1
Last active June 1, 2016 21:19
+------------+----------+
| store_id | amt |
|------------+----------|
| 1 | 110000.0 |
| 2 | 51400.0 |
| 3 | 70000.0 |
+------------+----------+
@nassredean
nassredean / window-blog-post-table-structure
Last active June 1, 2016 21:18
SALES STORES
+------+-----------+------------+----------+--------------+ +------+---------------+
| id | user_id | store_id | amount | entered_at | | id | name |
|------+-----------+------------+----------+--------------| |------+---------------|
| 1 | 1 | 1 | 10000.0 | 2015-11-07 | | 1 | Gucci |
| 2 | 1 | 1 | 30000.0 | 2015-11-29 | | 2 | Louis Vuitton |
| 3 | 1 | 2 | 11000.0 | 2015-11-08 | | 3 | Fendi |
| 4 | 1 | 2 | 19000.0 | 2015-11-26 | +------+---------------+
| 5 | 1 | 3 | 14000.0 | 2015-11-15 |
| 6 | 1 | 3 | 14000.0 | 2015-11-23 | USERS