SQL

Question

1.write a query that can give you all orders with amounts higher than $1000.
2.write a request that can give you the sname and city fields for all sellers in London with commissions above 10.
3.write a query to the table of customers whose output can include all customers with a score =<100 if they are not located in Rome.
4.That can be displayed as a result of the following query?
SELECT*
FROM Orders
WHERE (amt<1000 OR
NOT(odate= 10/03/1990
AND cnum >2003));
5.That can be displayed as a result of the following query?
SELECT*
FROM Orders
WHERE NOT((odate= 10/03/1990 OR snum >1006)
AND amt>=1500);
6.how can I easily rewrite such a request?
SELECT snum, sname,city, comm
FROM Salespeople
WHERE ( comm>+.12 OR
comm <.14);
7.prepare a report of the work done
-Report content:
-title page
-purpose of work
-sql query texts from the examples
-the results of the query
-conclusion

Answer 1

каша.