![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 11.02.2020 17:28 asaadasaadasaad6524
Write the following queries in SQL based on the following schema:COP5725 - Spring 2011• Product(maker, model, type)• PC(model, speed, ram, hd, price)• Laptop(model, speed, ram, hd, screen, price)• Printer(model, color, type, price)a) Give the manufacturer and speed of laptops with a hard disk of at least 30 gigabytesSELECT R. maker AS manufacturer, L.speed AS gigahertzFROM Product R, Laptop LWHERE L. hd>= 30AND R. model = L. modelAND R. type= ‘laptop’;b) Find the model number and price of all products (of any type) made by manufacturer 'B'SELECT R. model, P. price FROM Product R, PC PWHERE R. maker= 'B‘ AND R. model = P. modelUNIONSELECT R. model, L. price, FROM Product R, Laptop LWHERE R. maker= 'B‘ AND R. model = L. modelUNIONSELECT R. model, T. price FROM Product R, Printer TWHERE R. maker= 'B’ AND R. model = T. model ;c) Find those manufacturers that sell Laptops, but no PC'sSELECT R. makerFROM Product R, Laptop LWHERE R. model = L. model and R. Type= ‘Laptop’EXCEPTSELECT R. makerFROM Product R, PC PWHERE R. model = P. model and R. Type= ‘PC’ ;d) Find those hard-disk sizes that occur in two or more PC'sSELECT DISTINCT P1.hdFROM PC P1, PC P2WHERE P1.hd = P2.hd AND P1.model > P2.model ;Alternate SELECT DISTINCT P. hdFROM PC PGROUP BY P. hdHAVING COUNT(*) >= 2 ;
![ansver](/tpl/images/cats/User.png)
Answers: 2
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 23:30
Which text format is this, "the text is transcribed exactly as it sounds and includes all the utterances of the speakers. "?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 02:00
For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 16:00
An english teacher would like to divide 8 boys and 10 girls into groups, each with the same combination of boys and girls and nobody left out. what is the greatest number of groups that can be formed?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 02:00
How are we able to create photographs differently than 100 years ago? explain your answer in relation to your photograph you selected.
Answers: 1
You know the right answer?
Write the following queries in SQL based on the following schema:COP5725 - Spring 2011• Product(make...
Questions
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
History, 14.10.2019 01:30
![question](/tpl/images/cats/biologiya.png)
Biology, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/geografiya.png)
Geography, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/geografiya.png)
Geography, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
English, 14.10.2019 01:30
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 14.10.2019 01:30
![question](/tpl/images/cats/mat.png)
Mathematics, 14.10.2019 01:30
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/health.png)