--Chapter 4 Dotted Solutions for Informix, Section 4.2

--[4.1] (a)     
select ssno from people p where p.pname.mi is null;

--(c)
select p1.ssno, p2.ssno from people p1, people p2
     where p1.pname = p2.pname and p1.ssno < p2.ssno;

--[4.2] (a)
drop table students;
drop row type student_t restrict;

create row type student_t (
    sperson person_t not null,
    stuid int, 
    emailname varchar(30) 
    gradyear int        
);
create table students of type student_t (primary key (stuid));
