Hello why if I solved this codes it can't be done

Question

SELECT Name
FROM Films
WHERE Year >= 2010 AND Year <= 2020
ORDER BY Name;

Answer 1

Jamilu Abubakar Sadiq

Might be you did something wrong.

Here is your right query:

SELECT Name
FROM Films
WHERE production = 'Marvel Studios' AND Year >= 2010 ORDER BY Name;

Answer 2

Thanks sir it's done
I'll take notes from now on

Answer 3

Jamilu Abubakar Sadiq

You need only 'Marvel Studios' films so where is that condition?

Answer 4

Okay sir but when ever you write production they tell you to fixe it

Answer 5

Jamilu Abubakar Sadiq

Price should be > 400 not = 400

Read this line "purchase total exceeds $400"

Answer 6

Hello Sir please what about that
SELECT * FROM Orders
WHERE Price = 400
AND (Age > 40 OR Distance < 10)
ORDER BY Price;

Answer 7

You are managing a delivery office and need to prioritize your orders.
Order is considered a high priority order if
- the purchase total exceeds $400
and
- the customer's age is greater than 40 or the distance from the office to the delivery point is under 10 miles.

You are given the following 'orders' table with details:

Answer 8

Okay I fixed it
SELECT * FROM Orders
WHERE Price > 400
AND Age > 40 OR Distance < 10
ORDER BY Price;
but look how they doing

Answer 9

My output is
name, age, Distance, Price
Ann 24, 5, 250
George 63, 9, 250
Adam 38, 2, 500
Lisa 44, 13, 750

Answer 10

And Expected output is

Adam 38, 2, 500
Lisa 44, 13, 750

Answer 11

dhgdg

Answer 12

zbhg