1. SI schema contains customers that have bought one or more vehicles. They must be classified using the following criteria:
   1. Customers that have bought only one car (Bronze class)
   2. Customers that have bought two cars (Silver class)
   3. Customers that have bought more than two cars (Gold class)
   Using a single SELECT statement, display a list of customer names and what type of buyer they are for all those customers that have bought Land Rover car make(s).

Specialty Imports E-R Diagram saleinvno SALEINV CHAR(6) DATE saledate NOT NULL CAR CUSTOMER custname VARCHAR2(20) custstreet VARCHAR2(20) NOT NULL custcity VARCHAR2(20) NOT NULL custprovince CHAR(2) NOT NULL DEFAULT ON custpostal CHAR(7) 7 NOT NULL custhphone CHAR(13) NOT NULL custophone CHAR(13) NOT NULL carserial CHAR(8) custname VARCHAR2(20) salesman VARCHAR2(20) NOT NULL custname VARCHAR2(20) NOT NULL ) carserial CHAR(8) NOT NULL insfire CHAR(1) inscollision CHAR(1) insliability CHAR(1) insproperty CHAR(1) taxrate NUMBER(4.2) DEFAULT 13.0 licfee NUMBER(6,2) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) 4) NOT NULL extcolour VARCHAR2(12) NOT NULL ( cartrim VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinvno CHAR(6) purchcost NUMBER(9.2) freightcost NUMBER(92) carlistprice NUMBER(9.2) discount NUMBER(82) PROSPECT custname VARCHAR2(20) NOT NULL carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) ( caryear CHAR(4) carcolour VARCHAR2(12) ( cartrim VARCHAR2(16) SERVINV servinvno CHAR(5) servdate DATE NOT NULL custname VARCHAR2(20) NOT NULL ( carserial CHAR(8) NOT NULL partscost NUMBER(72) laborcost NUMBER(7.2) taxrate NUMBER(4.2) DEFAULT 13.0 ( commission NUMBER(8,2) carsaleprice NUMBER(9.2) optioncode CHAR2(4) Text PURCHINV TRADEINV SERVWORK saleinvno CHAR(6) carserial CHAR(8) servinvno CHAR(5) workdesc VARCHAR2(80) purchinvno CHAR(6) purchfrom VARCHAR2(15) purchdate DATE EMPLOYEE empname VARCHAR2(20) startdate DATE NOT NULL commissionrate NUMBER(3.1) title VARCHAR2(26) manager VARCHAR2(20) tradeallow NUMBER(9.2) BASEOPTION optioncode CHAR(4) carserial CHAR(8) INVOPTION OPTIONS optioncode CHAR(4) optiondesc VARCHAR2(30) optioncost NUMBER(72) optionlistprice NUMBER(7.2) () saleinvno CHAR(6) oc optioncode CHAR(4) optionprice NUMBER(7.2) )