Exercise 15.8 Consider the following relational schema and SQL query:
Suppliers(sid: integer, sname: char(20), city: char(20))
Supply(sid: integer, pid: integer)
Parts(pid: integer, pname: char(20), price: real)
SELECT S.sname, P.pnameFROM Suppliers S, Parts P, Supply YWHERE S.sid = Y.sid AND Y.pid = P.pid AND S.city = ‘Madison’ AND P.price ≤ 1,000
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.