D is the answer to the question hope it helps
Answer:
A. It can be touched.
Explanation:
The main difference between goods and services is that we can touch the goods, whereas we cannot touch the services. And we can touch computers, and hence it is good and not a service. Thus, "A it can be touched", is the correct option here.
Answer:
a) SELECT COUNT(*)
FROM Supplies
WHERE sid=T OR sid=X;
b) SELECT sid
CASE
WHEN sid=IMB AND pid=T
THEN 'YES'
ELSE 'No'
END AS 'check'
FROM Supplies
c) SELECT pid
WHERE partname != computers
FROM Parts
LEFT JOIN Supplies
ON Parts.pid=Supplies.pid;
d) SELECT color
FROM Parts
WHERE pid=T;
Explanation:
a) Here we will use aggregate function along with WHERE and operators to count for specifc part ids
b) This is a CASE query
c) This is again a case query but invloves two separate tables. So, here 1st required values from 1st table are selected and then table is joined with the other table using OUTER JOIN
d) This is again a CASE query. It can be written by calling upon the all the values in one column corresponding to values in another column
