SQL> select count(distinct driver_id#) from participated402,accident402 where ac
cd_date like '%16';

COUNT(DISTINCTDRIVER_ID#)
-------------------------
                        4


SQL> select model,count(participated402.regno) from participated402,car402 where
 participated402.regno = car402.regno group by model;

MODEL      COUNT(PARTICIPATED402.REGNO)
---------- ----------------------------
auto                                  2
suv                                   1
car                                   4

SQL> select count(participated402.regno) from participated402,car402 where model
 like 'suv' and participated402.regno = car402.regno;

COUNT(PARTICIPATED402.REGNO)
----------------------------
                           1


SQL> select name ONAME,count(regno) TACC,sum(damage_amt) TDAMAGE from person402
natural join participated402 group by name order by TDAMAGE desc;

ONAME            TACC    TDAMAGE
---------- ---------- ----------
Raghu               3      60000
Shyam               2      31000
Ram                 1      25000
Hari                1      23575

SQL> select name,count(driver_id#)  from person402 natural join participated402
group by (name) having count(driver_id#)>1;

NAME       COUNT(DRIVER_ID#)
---------- -----------------
Raghu                      3
Shyam                      2

SQL> (select name,driver_id# from person402) minus (select name,driver_id# from
participated402 natural join person402);

NAME       DRIVER
---------- ------
Rahul      KA1224

-----------------------------XXXXXXXXXXXXX-------------------------------------------
SQL> create table customer402(
  2  cust# number(5,0),
  3  cname varchar(20),
  4  city varchar(20),
  5  primary key(cust#));

Table created.



SQL> create table orders402(
  2  order# number(5,0),
  3  odate date,
  4  cust# number(5,0),
  5  ordamt number(5,0),
  6  primary key(order#),
  7  foreign key(cust#) references customer402(cust#));

Table created.