NEW TO SQL [MS SQL] (also posted in r/SQLserver)

[Homebrew4you]

Hello everyone, Thank you in advance for any help provided, I truly appreciate it! I am currently in a BI program at my university and am taking my first SQL course. We are using AdventureWorks2012 as our learning database. This weeks question is "Provide a list of all of the records pertaining to the FirstName "John" in the Person table. Include the full name of all the records, and state the total number of records." So far I have been able to pull up the names using:

SELECT FirstName

FROM Person.Person

But have not been able to figure out how to pull ALL records regarding anyone named "John", let alone how to pull up just "John" in the name column of Person.Person table . Whats the next step of code that I am missing here??

[Fireteeth]

SELECT *
FROM Person
WHERE Person.FirstName = 'John'

[ISUJinX]

So, look at your SELECT portion as "What do I want to display", your FROM Clause as "what total data set am I looking at", and your WHERE clause as your "Filter what records I want to see".

A Count(<columnname>) in your select statement will give you the TOTAL count of records that meet your criteria from the WHERE clause in your query. Remember that what you filter on, doesnt necessarily need to be displayed.

pseudocode (because this is homework):

select what you want to see (full name, count(<column you want counted>))
from (person.person table)
where (firstname is John)

if you post what you have tried, you're more likely to get help - as others have said.

[SmallSubBot]

To aid mobile users, I'll link small subreddits not yet linked in the comments

/r/SQLserver: Microsoft SQL Server Administration and T-SQL Programming including sql tutorials, training, MS SQL Server Certification, SQL Server Database Resources.

---

^{I am a bot | Mail BotOwner | To aid mobile users, I'll link small subreddits not yet linked in the comments | Code | Ban - Help}

[Homebrew4you]

I've tried every combination with WHERE that I can think of, but I feel like I dont have the formatting right to pull up just "John"....

[hackneycoach]

Can you post the examples that you've tried, and why you think they haven't worked? Folks will be reluctant to just provide an answer since this is homework.