Question

CAR レイ01 can-vm CAR TYPE CAR VIN BELONGS LO CAR COOE CAR COOE CAR MODEL 1:0 1N CAR CUST ar-Cust.iw K P CUST NUM SALE OATE EN BELONGS 0:N CUSTOMER 1:N SALE CUST NUM 1:N HELPED L SALE ID HELPS CUST FNAME SALE,DATE STAFF HR CUST LNAME N M CUST NUM CUST PHONE rk レ 11 TAFF-ID-NUM onl

A query that is based on more than two tables and includes both an arithmetic and a special operator in the conditional expression. Both the arithmetic and the special operator must be different from the ones used in part a

PART A.

Select Car_Cust.Cust_Num, Car_Model from Car_Cust inner join Car on Car_Cust.Car_VIN = Car.Car_VIN inner join Car_Type on Car.Car_Code = Car_Type.Car_Code where Car_Code = 'C123' and Car_Model IN('M1','M2','M3',M7');

I keep getting an error message ...

PART B . Need help with

5. Two additional complex queries designed by you that are different from the above. A complex query is based on two or more tables and includes either several conditions or a subquery (or both).

Select count(Cust_Phone_Num) from Customer inner join Sale on Customer.Cust_Num = Sale.Cust_Num inner join Staff on Sale.Staff_ID_Num = Staff.Staff_ID_Num group by Staff.Staff_ID_Num having Staff_Rnk = 1;

Error message on this one aswell, help please.