Practice Interview Questions
| Question | Status |
|---|---|
Your goal is to return the names of the student that starts with the letter 'A' (it can also start with lower caps) along with their count. Let’s say table has "Alan" and "adam" as entry. The output should be 2, Alan, adam (delimited by a comma and a space).
To answer this question, you will use the students table.
students table:
| Column Name | Description |
|---|---|
| first_name | The first name of the student. |
| output |
|---|
| 2, Alan, Adam |
Your goal is to return the names of the student that starts with the letter 'A' (it can also start with lower caps) along with their count. Let’s say table has "Alan" and "adam" as entry. The output should be 2, Alan, adam (delimited by a comma and a space).
To answer this question, you will use the students table.
students table:
| Column Name | Description |
|---|---|
| first_name | The first name of the student. |
| output |
|---|
| 2, Alan, Adam |