HW lesson 7 deadline 28.09

helga-spivak commented 2 years ago

Вашей домашкой бдет сделать задачи: 17, 18, 19, 21, 22 (https://www.sql-ex.ru/) - мне скринуть скрины (оформить в один документ) такого плана (видно номер задачи, ваш код и что запрос верный) Щфщрмляем все в гугл доках

https://www.w3schools.com/sql/default.asp - тут почитать и выучить все что проходили на уроке:

SQL SELECT DISTINCT, SQL WHERE SQL AND, OR and NOT Operators SQL ORDER BY SQL INSERT INTO SQL UPDATE SQL DELETE SQL TOP, LIMIT, FETCH FIRST or ROWNUM SQL MIN() and MAX() SQL COUNT(), AVG() and SUM() SQL LIKE SQL IN SQL BETWEEN

Решение задач, пройденных на уроке 1.select model, speed, hd размер from PC where price < 500

2.select DISTINCT maker from product where type = 'printer'

3.select model, ram, screen from Laptop where price > 1000

4.select * from Printer where color = 'y'

5.select model, speed, hd from PC where cd in ('12x', '24x') and price < 600

10.select model, price from Printer where price = (select max (price) from Printer)

11.select avg(speed) as speed from PC

12.select avg (speed) speed from laptop where price > 1000

13.select avg (speed) as speed from PC where model in (select model from product where maker = 'A')

15.select hd from pc group by hd having count(model) > 1

16.select distinct B.model as test1, A.model as test, A.speed, A.ram from PC as A, PC as B where B.speed = A.speed and B.ram = A.ram and A.model < B.model