合生元碰到的sql
Consider the following schema:
Suppliers( sid: integer, sname: string , address: string )
Parts( pid : integer, pname: string ,color: string )
Catalog( sid: integer, pid: integer, cost: real )
The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in SQL.
找出仅供应红色零件的 供应商的sids (除了红色不提供别的)
2)找出供应一种红色零件或一种绿色零件的供应商的sids