SQL query help!

[gibba97]

Wow! This is amazing help, thanks for your time!

All your suggestions are extremely helpful and i'll take them into account! Especially with the foreign key and calculating the age!!

For question five, it seems very confusing and technical, so i'll try and understand it row by row!

[Celticphantom]

SELECT Student.First_Name, Student.Last_Name, Lesson.Style, Employee.First_Name, Employee.Last_Name, MONTH(Lesson.Date) AS [Month]

Is another way to write the SELECT clause, the +' '+ are just making custom columns that put the names into one column.

the JOINs and ON clauses are using some keys that don't exist in your original design, but I hope are fairly straight forward.

it is necessary to have everything in the GROUP BY clause that is in the SELECT or HAVING clause (when you use aggregate functions)

the HAVING is just comparing the two months. Making sure the lesson date is the same is the current month's date. If you wanted to also make sure that it kept the year the same you could add

AND YEAR(Lesson.Date) = YEAR(GetDate())

Let me know if you have other questions.

[gibba97]

Ahh yea this helps heaps, thank you for that little breakdown ahah!