![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 03.04.2020 02:49 trivettkrchs6060
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 bySuppliers. Write the following queries in SQL:1) Find the sids of suppliers who supply a red part and a greenpart.2) Find the sids of suppliers who supply a red part or a greenpart.3) For every supplier that only supplies green parts, printthe name of the supplier and the total number of parts that shesupplies.4) For every supplier that supplies a green part and a redpart, print the name and price of the most expensive part that shesupplies
![ansver](/tpl/images/cats/User.png)
Answers: 1
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 18:00
Determine whether the following careers would require training or college.
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 05:00
In cell b18, enter a formula to calculate the amount budgeted for meals. this amount is based on the daily meal allowance and the total travel days (# of nights+1).
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 13:30
Anetwork security application that prevents access between a private and trusted network and other untrusted networks
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 17:00
*! 20 points! *jeff wants to create a website with interactive and dynamic content. which programming language will he use? a. dhtml b. html c. css d. javascript
Answers: 1
You know the right answer?
Suppliers(sid: integer, sname: string, address:string)Parts(pid: integer, pname: string, color: stri...
Questions
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/himiya.png)
Chemistry, 19.04.2021 22:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 19.04.2021 22:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 19.04.2021 22:40
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/nemec.png)
German, 19.04.2021 22:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 19.04.2021 22:40
![question](/tpl/images/cats/mat.png)
Mathematics, 19.04.2021 22:40
![question](/tpl/images/cats/mat.png)
Mathematics, 19.04.2021 22:40