Hello everyone. I have a question. What is the best way to implement the following two queries using MySQL.

A table called PEOPLE containing "people"

id - number
id_group – group number
id_type - type

Table called GROUP containing "groups of people"

id - number
name – group name
dt – date of creating

I need to output the following information with 2 queries:

1. id ("number"), name ("groupname"), dt ("date"), number of people ("numofpeople") - only groups not containing people with NULL type (but can contain zero people).

2. The same thing, but amount of people is counted without any resitriction on people with NULL type. All counted.

Please, if that is possible, comment out the code.

Great thanks! Excuse my English.

will one query be okay instead of two?