You have an SQL table (in your favorite SQL database) that looks like this.

| userid | date | city |
| ------ | ---------- | -------- |
| 1 | 2015-03-01 | Seattle |
| 1 | 2015-04-06 | Portland |
| 22 | 2015-02-23 | New York |

1. Write a query to count thenumber of rows per month for Seattle.
2. Write a query to identify the month with the most rows for Seattle.
3. What flavor of SQL did you write your above answer in?

Question

You have an SQL table (in your favorite SQL database) that looks like this.


| userid | date       | city     |
| ------ | ---------- | -------- |
| 1      | 2015-03-01 | Seattle  |
| 1      | 2015-04-06 | Portland |
| 22     | 2015-02-23 | New York |

1. Write a query to count thenumber of rows per month for Seattle.
2. Write a query to identify the month with the most rows for Seattle.
3. What flavor of SQL did you write your above answer in?

Evidation Health

Evidation Health interview question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches