create table student (id number, 
	f_name varchar(20), 
	birthday date, 
	num_children integer, 
	birth_city varchar(30), 
	birth_state varchar(10)
);

insert into student values (1,'Phil',to_date ('1950-12-12','YYYY-MM-DD'),NULL,NULL,NULL);
insert into student values (2,'Peter',to_date ('1960-12-12','YYYY-MM-DD'),4,'Raleigh','NC');
insert into student values (3,'Mary',to_date ('1970-12-12','YYYY-MM-DD'),2,NULL,'LA');
insert into student values (4,'Hugh',to_date ('1971-12-12','YYYY-MM-DD'),0,NULL,'FLA');
insert into student values (5,'Rachel',to_date ('12-12','MM-DD'),1,NULL,'Fla');
insert into student values (6,'Paul',NULL,1,NULL,NULL);


select count(*) from student;
select count(id) from student;
select count(birth_state) from student;

select count(id), f_name, birth_state from student group by f_name, birth_state;

select count(id), f_name, birth_state from student group by f_name,  birth_state having birth_state like '%LA%';