---
# System prepended metadata

title: SQL Interview (R. A. Marino)

---

SQL Interview (R. A. Marino)
===
### Date : 2022-07-12

Scenario: The Data Science team has been asked to visualize customer usage of GitHub Issues including historical usage. There are a series of SQL queries to write for building the Issues dashboard.

### Sample Schema


issue_usage table (calculated daily, one record per user per day if they used Issues that day) |  |
|:---|:---| 
usage_date (date) | 
user_id (bigint) |

<br>

user_team table - find out which teams a user is a member of, if any  | |
:-- |:-- |
user_id (bigint) | 
team_type (varchar) |

<br>
<br>

1. What are all of the different team types?

``` sql - add response below




```


2. How many Issues users were there yesterday?
``` sql - add response below




```

3. What are the top 10 team types by Issues user count?
``` sql - add response below




```

4. How many new Issues users have there been in the last 28 days?


``` sql - add response below




```

5. How many Issues users with the team_type of 'Awesome' had more than one day of usage in the last 28 days?


``` sql - add response below




```