Using the above relational schema, determine whether the following query is both type and semantically correct:

What will be an ideal response?

```
SELECT CO.orderNo, C.cAddress, OD.itemNo

FROM OrderDetail OD, ClientOrder CO, Client C, Office O, Area A
WHERE CO.clientNo = C.clientNo AND
C.officeNo = O.officeNo AND
O.areaNo = A.areaNo AND
A.areaDescription = ‘SE’ AND
C.cName = ‘J. Smith’;
```
Query graph will show that OrderDetail has no join to the other relations, although it is
connected to the Result. Should conclude that it is not semantically correct.