SQL> set echo on SQL> start ddl.sql SQL> create table question( 2 email varchar(35) not null, 3 recdate date not null, 4 name varchar(50) null, 5 question varchar(500) not null); Table created. SQL> SQL> alter table question 2 add constraint Email_Date_PK primary key (email, recdate); Table altered. SQL> SQL> desc question; Name Null? Type ----------------------------------------- -------- ---------------------------- EMAIL NOT NULL VARCHAR2(35) RECDATE NOT NULL DATE NAME VARCHAR2(50) QUESTION NOT NULL VARCHAR2(500) SQL> SQL> alter table question 2 drop constraint Email_Date_PK; Table altered. SQL> SQL> alter table question 2 add question_ID number(5) primary key; Table altered. SQL> SQL> desc question; Name Null? Type ----------------------------------------- -------- ---------------------------- EMAIL NOT NULL VARCHAR2(35) RECDATE NOT NULL DATE NAME VARCHAR2(50) QUESTION NOT NULL VARCHAR2(500) QUESTION_ID NOT NULL NUMBER(5) SQL> start questions.sql SQL> insert into question 2 (question_ID, email, name, recdate, question) 3 values 4 (1, 'bob@ge.net', 'bob', '3 march 2000', 'Do you have blue hookahs?'); 1 row created. SQL> insert into question 2 (question_ID, email, name, recdate, question) 3 values 4 (2, 'bob@ge.net', 'bob', '4 march 2000', 'Do you have green hookahs?'); 1 row created. SQL> insert into question 2 (question_ID, email, name, recdate, question) 3 values 4 (3, 'jim@tallmen.com', 'Jim Johnson', '4 april 2000', 'How tall is your tallest hookah?'); 1 row created. SQL> insert into question 2 (question_ID, email, name, recdate, question) 3 values 4 (4, 'gina@cocacola.com', 'Gina Swanson', '6 June 2000', 'Where can I find the elusive cola shisha?'); 1 row created. SQL> insert into question 2 (question_ID, email, name, recdate, question) 3 values 4 (5, 'fred@saveyoursoul.org', 'Frederick', '6 June 2000', 'Hookah smoking is an evil, drug-crazed activity!'); 1 row created. SQL> start dml.sql SQL> select distinct email from question; EMAIL ----------------------------------- bob@ge.net fred@saveyoursoul.org gina@cocacola.com jim@tallmen.com SQL> SQL> select distinct email from customer 2 where email NOT in ( 3 select email from question); EMAIL ---------------------------------------- bend@msn.com bunny@hotmail.com ping@ucl.ac.uk steve@apple.com SQL> SQL> select count(email) from customer 2 where email in ( 3 select email from question); COUNT(EMAIL) ------------ 2 SQL> SQL> select description from product 2 where product.name NOT IN ( 3 select name from order_prod); DESCRIPTION -------------------------------------------------------------------------------- Small Hookah Regular Shisha: Strawberry SQL> SQL> select firstname, lastname from customer, sdorder, order_prod 2 where customer.customer_ID = sdorder.customer_ID 3 AND sdorder.sdnumber = order_prod.sdnumber 4 AND order_prod.name = 'regmint'; FIRSTNAME LASTNAME -------------------- -------------------- Bobbi Sekis SQL> SQL> select country, sum(profit), count(sdnumber) from sdorder, customer 2 where sdorder.customer_ID = customer.customer_ID 3 group by country 4 order by count(sdnumber) desc; COUNTRY SUM(PROFIT) COUNT(SDNUMBER) -------------------- ----------- --------------- USA 112 3 UK 62 2 Mexico 195 1 Mongolia -5.2 1 SQL> SQL> spool off