A
A
adun32015-11-07 10:57:25
SQL
adun3, 2015-11-07 10:57:25

Why is one request better than another?

Hello!
I decided to learn the basics of sql by solving problems on sql-ex.ru I'm
just starting out, so I don't understand why the site decided that the query

SELECT AVG(speed) FROM Laptop WHERE Laptop.price IN
(SELECT price FROM Laptop WHERE price > 1000)

better than
SELECT AVG(speed) FROM Laptop WHERE price > 1000 ( или laptop.price)

Tell me please

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question